This is the formula "=IF(ISNUMBER(VLOOKUP(RC[-1],NSW!C1,1,0)),NSW!R2C6,IF(ISNUMBER(VLOOKUP(RC[4],NSW!C2,1,0)),NSW!R2C7,""))"
Its working fine. I have the list of states with its local holidays, I need to add a condition to this formula, for EG if = "NSW" then it refers to NSW sheet and do the above function,
ROWS and Columns are same for all the states
Solved by E. A. in 26 mins