Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |