SOLVED

Excel find a header from Spreadsheet with two variables

Copper Contributor
Pipe in Feet Size of Pipe in Inches
 1/2"3/4"1"1-1/4"1-1/2"2"2-1/2"3"
101082303877931237225936406434
2075160280569877161026135236
3061129224471719133521654107
4052110196401635114318673258
504698177364560104116802936
60428915933651395715592684
70388214931747689614472492
80367614023944384013532315
90337113327542079312882203
100326812626641177512462128
125286011724336970011431904
150255410521532762510081689
1752350931963035839931554
2002247841822805418771437
3001737701452244396861139

need to return header based on length of gas piping and amount of gas required.

Any good equations that come to mind?

2 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

@Greg_K1958 

=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.

header of spreadsheet.JPG

 

This works Great, Thank you!!!!!
1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

@Greg_K1958 

=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.

header of spreadsheet.JPG

 

View solution in original post