Use concatenate to bring the two values together e.g you have to be careful
depending on what type of values column A and B are......

=VLOOKUP(CONCATENATE(A1,B1),X1:Z100,2,FALSE)

--

Regards,
Nigel




wrote in message
...
How can I set the formula for vlookup more than 1 cells?

e.g.
Sheet 1 columns A and B vlookup to another Sheet 2 columns C

I need to get back the result for columns C