MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combine hlookup & vlookup?


Posted by sam on November 01, 2001 10:25 AM

i have a 20x5 table and need to find a cell using the top column and far left column. what is the best way to do this? the cell needs to be found using a lookup to the left and combining with a lookup on the top row.


Posted by Juan Pablo on November 01, 2001 10:32 AM

Try using something like

=INDEX(Yourtable,MATCH(Column),MATCH(Row))


Juan Pablo

Posted by sam on November 01, 2001 12:36 PM