Hello Nick from Steved

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

Thanks.

"Nick Hodge" wrote:

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
HIS


"Steved" wrote in message
...
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.