double or nested vlookup
=INDEX(C1:C20,MATCH("C5",A1:A20&B1:B20))
Confirm that formula with CTRL-SHIFT-ENTER to activate the array. You will
see braces appear around your formula { } and the formula should return the
value from cell C15.
--
"Actually, I AM a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"PaulaB" wrote:
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
|