vlookup and hlookup simultaneously
 

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

vlookup and hlookup simultaneously
 

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

vlookup and hlookup simultaneously
 

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

"Kanagabalan" wrote:

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