Forum Discussion
Solved
Excel find a header from Spreadsheet with two variables
Pipe in Feet Size of Pipe in Inches 1/2" 3/4" 1" 1-1/4" 1-1/2" 2" 2-1/2" 3" 10 108 230 387 793 1237 2259 3640 6434 20 75 160 280 569 877 1610 2613 5236 30 ...
=INDEX($B$2:$I$2,,MATCH(A21,OFFSET($B$3:$I$3,MATCH($A$23,$A$3:$A$17,0)-1,0),0))You can try this formula which seems to work in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=INDEX($B$2:$I$2,,MATCH(A21,OFFSET($B$3:$I$3,MATCH($A$23,$A$3:$A$17,0)-1,0),0))You can try this formula which seems to work in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
This works Great, Thank you!!!!!