$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give #

S

Steved

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.
 
S

Steved

Hello Nick from Steved

It's Monday morning in New Zealand hence the reson I feel stupid.

Thanks.
 
S

Steved

Hello Davesexcel

I've carried out what you have explained and it was what I was not doing,
and now is all well.

Thankyou.
 
Top