vlookup and hlookup simultaneously

[Kanagabalan]

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

 

[Peo Sjoblom]

http://www.contextures.com/xlFunctions03.html#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

 

[JMB]

Use a combination of Index/Match or Offset/Match

http://j-walk.com/ss/excel/usertips/tip020.htm
http://www.cpearson.com/excel/lookups.htm#LeftLookup