vlookup

[Guest]

I'm putting a vlookup for my drivers names so I can enter just their initials
and get their name in a corsponding cell but how can I get their route
numbers to be entered in another cell

1A driver initials
1B drivers name
1C Route numbers

 

[Guest]

Hi Tankerman,

You could do a Vlookup on a Vlookup result:-

=VLOOKUP(E1,A1:B50,2,FALSE)

Lets say the above (In E2) would look at the initials you entered (In E1)
and return the corresponding name.

=VLOOKUP(E2,B1:C50,2,FALSE)

The second Lookup would look at the result of the first and return the route.

I hope you don't have 2 drivers with the same initials or surname.

Mike

 

[Guest]

Mike thanks it works great but is there anyway to hide the #NA in all the
blank cells

 

[T. Valko]

One way:

=IF(ISNA(VLOOKUP(E1,A$1:B$50,2,0)),"",VLOOKUP(E1,A$1:B$50,2,0))

Biff