J

#### J.W. Aldridge

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...?