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
|