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

[Guest]

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.

 

[Nick Hodge]

Steve

You are looking up an offset of with a lookup range which only has 3
columns A:C

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[davesexcel]

the "4" means column 4 in your range
you don't have 4 columns

 

[davesexcel]

you need to expand your range

 

[Guest]

Hello Nick from Steved

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

Thanks.

 

[Nick Hodge]

Must try harder... I didn't hit the 4 key hard enough....

You are looking up an offset of '4' with a lookup range which only has 3
columns A:C


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Guest]

Hello Davesexcel

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

Thankyou.