J
J.W. Aldridge
I understand how Index/Match works with double lookups... But I cant
quite get the third lookup down.
Looking to add a third lookup value and range to this formula (range
z)
=INDEX(table, MATCH(x,range x,0), MATCH(y,range y,1))
Data is laid out like so... (Vertical column range is x)
A B C D E F G H
1 range yyyyyyyyyyyyyy ->
2 range zzzzzzzzzzzzzz ->
x
x
x
x
x
x
any suggestions...?
quite get the third lookup down.
Looking to add a third lookup value and range to this formula (range
z)
=INDEX(table, MATCH(x,range x,0), MATCH(y,range y,1))
Data is laid out like so... (Vertical column range is x)
A B C D E F G H
1 range yyyyyyyyyyyyyy ->
2 range zzzzzzzzzzzzzz ->
x
x
x
x
x
x
any suggestions...?