VLookup & IF

  • Thread starter Thread starter anna
  • Start date Start date
A

anna

Is there a way of the vlookup function not to return the
value N/A when the result is false?

Do i need to write a if condition?

Anna
 
anna,

Niek Otten is suggesting that you put your VLOOKUP formula wherever he shows
YourFormula -

i.e. in the cell enter

=IF(ISNA(VLOOKUP(..etc... )),"",VLOOKUP(..etc... ))

where VLOOKUP(..etc... ) is your formula that you want to use.

regards,

JohnI
 
=VLOOKUP(O89,Synnex!$A$4:$D$929,4,FALSE)

Above is the formula i am using.

When true it basically grabs a price from a spreadsheet
called synnex and plugs it into the current spreadsheet.

When false i don't want it to write n/a instead i want
the current spreadsheet to keep it current value and not
be overwritten.

understand?
 
anna,

So use as your formula-

=IF(ISNA(VLOOKUP(O89,Synnex!$A$4:$D$929,4,FALSE)),"",VLOOKUP(O89,Synnex!$A$4
:$D$929,4,FALSE))

or -----

=IF(ISNA(VLOOKUP(O89,Synnex!$A$4:$D$929,4,FALSE)),O89,VLOOKUP(O89,Synnex!$A$
4:$D$929,4,FALSE))


whichever one works for you.

regards,

JohnI
 
Back
Top