One way:

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

Biff

"tankerman" wrote in message
...
Mike thanks it works great but is there anyway to hide the #NA in all the
blank cells

"Mike" wrote:

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






"tankerman" wrote:

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