Why Isn't This Formula Working?

[thewiseguy]

Hi Everyone,

Not sure why this formula is a returning an "n/a" value? I have the same formula in a cell to the left and I copied everything over, however it is still not returning the needed values. Can anyone point to what may be wrong?

Thank you in advance!

-m


=IF(N5="","",IF(ISERROR(VLOOKUP(N5,PROPOSED!$A$5:$I$65536,7,FALSE)),0,

 

[Jonmo1]

We can't see the whole formula... it got cutoff after the 0

Put spaces around any < or > symbols, the board software sometimes thinks they are HTML code tags..

 

[Andrew Poulsom]

You haven't posted the entire formula have you?

 

[thewiseguy]

yes that is the entire formula. it works in 1 section of my worksheet but not when i copy it over.

 

[Jonmo1]

That can't be the entire formula...It's incomplete.

You posted
=IF(N5="","",IF(ISERROR(VLOOKUP(N5,PROPOSED!$A$5:$I$65536,7,FALSE)),0,
Or at least that's all we can see.....

It tells what to do if the vlookup is an error (return a 0), but there is nothing after that. It's incomplete..
It needs to continue on and state what to do if the vlookup is NOT an error..presumably complete the vlookup.

I assume it should be
=IF(N5="","",IF(ISERROR(VLOOKUP(N5,PROPOSED!$A$5:$I$65536,7,FALSE)),0,VLOOKUP(N5,PROPOSED!$A$5:$I$65536,7,FALSE)))

 

[StuartWhi]

Hi M,

If you are looking for a simple test of your Vlookup is true this could be the formula you are looking for.

=IF(N5="","",IF(ISERROR(VLOOKUP(N5,Proposed!$A$5:$I$65536,7,FALSE)),0,"It's working"))

Regards,

Stuart.

 

[thewiseguy]

That can't be the entire formula...It's incomplete.

You posted
=IF(N5="","",IF(ISERROR(VLOOKUP(N5,PROPOSED!$A$5:$I$65536,7,FALSE)),0,
Or at least that's all we can see.....

It tells what to do if the vlookup is an error (return a 0), but there is nothing after that. It's incomplete..
It needs to continue on and state what to do if the vlookup is NOT an error..presumably complete the vlookup.

I assume it should be
=IF(N5="","",IF(ISERROR(VLOOKUP(N5,PROPOSED!$A$5:$I$65536,7,FALSE)),0,VLOOKUP(N5,PROPOSED!$A$5:$I$65536,7,FALSE)))

haha thank you! not sure why but because i didnt drop open the entire formula bar, it only copied part of the formula.

thank you again for your help!