Forum Discussion
Formula Help Please
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 ...
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)
