View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default double or nested vlookup

Insert an extra column in which you concatenate A and B (=A1&B1).
Concatenate the search arguments too.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"PaulaB" wrote in message
...
Is there a way to look up not just one value, but two, in order to give an
output?
For example, column A has values A through D, repeated 5 times, and column
B
has 1 through 10 repeated twice. Column C is the output value. How to I
get
another worksheet to give me the value from C and 5 since Vlookup will
only
find either C or 5?
--
Thanks,
Paula