vlookup
 

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

vlookup
 

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

vlookup
 

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

vlookup
 

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