Hello,

I was wondering if someone would be able to help with an issue i am having with a spreadsheet. The spreadsheet has two worksheets, the first that works as a search box and then a second that contains the data table.

I was wondering if it is possible to use INDEX MATCH to look along a row to find a match, then use that column for the result once the second part of the equation gets the result.

the equation i have used is

=INDEX(MATCH('Top Sheet'!A2,'Data Sheet'!2:2,0),MATCH('Top Sheet'!A4,'Data Sheet'!B:B,0))

which is throwing up and error i can get it to bring up the column number that the result is in, but i dont know how to use that number to get the code to then use that for the result column.

datasheet.xlsx

Thats a copy of the spreadsheet, if anyone has any ideas i would be really grateful.

Thanks

Mike