Hello,
=INDEX(Price,Match(B1,Height,1),Match(B2,Width,1))
http://boisgontierjacques.free.fr/pa....htm#IndexPrix
http://boisgontierjacques.free.fr/fi...EquivPrix1.xls
JB
http://boisgontierjacques.free.fr/
On 1 sep, 19:06, John in PA <John in
wrote:
I have data in a table and would like to retrieve it from a column figure
derived from one cell and a row figure from a second cell. Basically, enter
the table with a column request from one cell and a row request from another
cell and display the intersecting value in the table in a third cell. Hope
this makes sense.
John in PA