Need more help please

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Hi Ron,

if i understood you correctly you want to search with the unit number
and return the Truck type. So you have a table in which column A
(A1:A62) stores the unit number and column B stores the truck type. the
use the following
=VLOOKUP(unit_number_to_search,$A$1:$B$999,2,FALSE)

this will return the Truck type (2nd column) for the unit number:
unit_number_to_search

HTH
Frank
 
Just to add to Frank's suggestion:

You could set up the formula so that you could enter the unit number into a
particular cell, and not have to change and/or update the formula itself in
order to return information on other units.

For example, set up cell C1 to enter the unit you are searching for,
And enter this in C2:

=VLOOKUP(C1,A1:B62,2,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi Ron,

if i understood you correctly you want to search with the unit number
and return the Truck type. So you have a table in which column A
(A1:A62) stores the unit number and column B stores the truck type. the
use the following
=VLOOKUP(unit_number_to_search,$A$1:$B$999,2,FALSE)

this will return the Truck type (2nd column) for the unit number:
unit_number_to_search

HTH
Frank
 
Good point
Frank
Just to add to Frank's suggestion:

You could set up the formula so that you could enter the unit number
into a particular cell, and not have to change and/or update the
formula itself in order to return information on other units.

For example, set up cell C1 to enter the unit you are searching for,
And enter this in C2:

=VLOOKUP(C1,A1:B62,2,0)
Click to expand...
 
Back
Top