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
|