Thank you Chris for your helpful words. I was distracted by a busy office, thus did not go into detail. I apologize for the lack in detail.
I am currently using ARCMAP 10.3 with a personal database. Accuracy desired: I would like for the map to know exactly where each street light is with X,Y coordinates, a matching street name, and the street lights to have accurate pole numbers.
So when I was first introduced to this project, I was handed a spread sheet from the local electric company. This spread sheet held the information for the street lights that I was to use for my mapping. This spread sheet held information such as: "route and route prefix" (route and then the pole within the specified route), "account number" ( which is used for who pays for the light to be on), "Street name" (which is the name of the street and was accompanied by other arbitrary numbers i was not informed about), "light fixture type", "TD" (also arbitrary to the planning office's knowledge), and the last one i should mention is "Town Name" (just the initials). This spread sheet did not include elevation or an X,Y coordinate system for the light poles.
The GIS attribute table is different. This includes FID, LAYER, HANDLE, ELEVATION, X,Y COORDINATE (when clicked on with the information tool), the rest of the attribute table either has information such as that the street lights are a "point" data and other un-useful data because there are at least 10 fields covered in nothing but zeros.
It became difficult using the information from the spread sheet to use for the GIS layer because the two data sets are very inconsistent with each other. When I join the data I had previously made through MS EXCEL with a current layer such as town roads or the street light layer, the information does not fully join (many of the fields read "NULL").
Please allow a delay for photos of the databases since I am out of the office until Thursday.
Thank you again, Geonet users!