IFISNAVLOOKUP no return if no value

[cyoungtx]

The formula below works for my sheet, however...

how do I change it so that if there is no value in C2 then there is no return. With this SOLD is returned when C2 is empty.

=IF(ISNA(VLOOKUP(C2,InventoryNumber, 1, 0)),"SOLD","")

Thanks for reading

 

[AMAS]

Maybe try this:

=IF(ISBLANK(C2),"",IF(ISNA(VLOOKUP(C2,InventoryNumber, 1, 0)),"SOLD",""))

AMAS

 

[AlphaFrog]

Try something like this...
=IF(C2="","",IF(ISNA(VLOOKUP(C2,InventoryNumber, 1, 0)),"SOLD",""))

 

[cyoungtx]

Yes, that's works! Thanks for the fast replies and the information!