Formula Help Please

Copper Contributor

Hi, I'm trying to select a number which is an intersection in 4 columns by about 20 rows where it gets the references for the headings and column names from other cells. Got a little confused. Would appreciate some help and have attached the spreadsheet.

 

The first number would go in cell e34 of the QACostCalculator tab, using cell c7 as one of the references and cell b34 as the other - these would be used to choose a value from the table in tab VariableFile tab, starting at b27, i that makes sense?

 

Thank you, Julian

2 Replies

@Julian_G57 

That could be

=IFNA(INDEX(VariableFile!$D$28:$G$48,
    MATCH($B34,VariableFile!C$28:C$48,0),
    MATCH($C$7,VariableFile!$D$27:$G$27,0)
),0)

 

@Sergei Baklan Thanks, I'll have a look

 

Regards Julian