Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup for two value
I want to use VLOOKUP function with, two Look_value, I didn't try but I think
I can do it with CONCATENATE function. But is there any other way. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup for two value
"AhmetDY" wrote: I want to use VLOOKUP function with, two Look_value, I didn't try but I think I can do it with CONCATENATE function. But is there any other way. Can you give an example of what you mean? You can say if in cell A1 you have the text "cat" and in cell a2 you have "dog", you could do a lookup in a table elsewhere for the value catdog by doing vlookup(a1&a2,table reference, colum ref,false) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |