G
Guest
I have several types of trucks, ie Quads, Tri-Axles, Water, Agitors, etc. Each of my trucks have a unit number. I would like to search a range such as A1:A62 for example that contain all my unit numbers. Based on the unit numbers in that range, I want a cell to return the type of truck. For example, IF(A1:A62=CERTAIN UNIT NUMBERS, RETURN "QUAD", IF OTHER UNIT NUMBERS, RETURN "WATER"
I hope I am explaining this well enough. Any help is greatly appreciated
Thanks
Ron
I hope I am explaining this well enough. Any help is greatly appreciated
Thanks
Ron