vlookup

T

tankerman

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
 
M

Mike

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
 
T

tankerman

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