I have two spreadsheets. On one of them it has a column that I want to input a formula that will look at the 2nd sheet and in a specific range of cells looks for "12-13'". If one of those cells contains that data, I want the return value to be the header of the column that the data was found in.
This is the formula I have tried and it doesn't work, any suggestions. I want the formula in Sheet 1 F3 and I will drag it down once it works.
=IF('Sheet2'!$D3:$J3<>"12-13'",INDEX('Sheet2'!$D$2:$J$2,3,MATCH("12-13'",'Sheet 2'!$D3:$J3,0)),"")
Test Spreadsheet.xlsx
Bookmarks