I am assuming the your database is in col A1 to C114 under sheet named List
in the same workbook and that you want to look up the match value in B24.
Otherwise you need to elaborate more.

Try this formula, it return a blank for no matching data found


IF(ISNA(VLOOKUP(B24,List!$A$1:$C$114,2,FALSE)),"", (VLOOKUP(B24,List!$A$1:$C$114,2,FALSE))

regards,

"ajaminb" wrote:

I have a quote form in Excel. Right now, if I have a zero in the Qty column
it shows the zero, the Sku# in the next column, description in next, and so
on.

If I remove the zero and the part number, the remaining cells in the row
show "NA"; I would like them to appear blank until the number 1 or otherwise,
and the Sku# are put in the fields.

This is the formula I'm using now in the description filed:
=IF(B24="","",VLOOKUP(B24,List!$A$1:$C$114,2,FALSE ))
--
AjaminB