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

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.

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

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.

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

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


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=557723

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

you need to expand your range


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=557723

$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Gi
 

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.

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

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
HIS


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

$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Gi
 

Hello Davesexcel

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

Thankyou.

"davesexcel" wrote:


you need to expand your range


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=557723