Forum Discussion

Greg_K1958's avatar
Greg_K1958
Copper Contributor
Jul 06, 2022
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"
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?

excel
  • OliverScheurich's avatar
    OliverScheurich
    Jul 06, 2022

    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.

     

2 Replies

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jul 06, 2022

    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.

     

Resources