Using a column number found using MATCH to act as the INDEX column field

[dugwan]

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

[JBeaucaire]

In A6:
=INDEX('Data Sheet'!$A$1:$BO$36, MATCH($A$4, 'Data Sheet'!$B$1:$B$36, 0), MATCH($A$2, 'Data Sheet'!$A$2:$BO$2))

[dugwan]

You are a wonderful wonderful person thank you