Hello from Steved

I have a spreadsheet that has columns for each month the below works fine in
col's 2 ( Month 2 )and 3 ( Month 3 ) but in Col 4 ( Month 4 )it givesme a
#REF! value. I've change ( $A$2:$C$1972,4,FALSE) the 4 to 2 and is ok, and
the same for 3 and is ok but when I put in 4 it gives me an #REF! Can you
please advise aswhat I can do.

=IF(ISNA(VLOOKUP(A2,'From Steve
Marsh'!$A$2:$C$1972,4,FALSE)),0,VLOOKUP(A2,'From Steve
Marsh'!$A$2:$C$1972,4,FALSE))
Thankyou.