#REF Error in index match formula

[Kristine Pacia]

Hi everyone need help,

in per payroll (gross income sheet) c7, #ref error appeared when the formula in b7 worked perfectly.

 

[rahulshewale1]

Hi @Kristine Pacia ,
See if it is ok ?
Using Helper Column

Sheets "LFPC 2020" in A2 Formula : ==H2&D2 ( DEPARTMENT/POSITION& Dates)
Per Payroll (Gross Income) C7 =VLOOKUP($A7&C$3,'LFPC 2020'!$A$1:$AU$64,47,FALSE)

 

[Fluff13]

In C7 try
=INDEX('LFPC 2020'!$AT$2:$AT$63,MATCH($A$7&"|"&C3,INDEX('LFPC 2020'!$G$2:$G$63&"|"&'LFPC 2020'!$C$2:$C$63,0),0))