Vlookup for two value

A

AhmetDY

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.
 
M

Mich modulus 11

AhmetDY said:
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.
Click to expand...

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)
 
Top