http://www.contextures.com/xlFunctio...ml#IndexMatch2

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Kanagabalan" wrote in message
...
I am trying to pick a value from a table. The table contains the results of
different combinations of X and Y. I am having diiferent x values in the
column and diiferent y values in the row. Based on the X Y combination, it
should pick the value from the table.

Regards

GKB