=if(isna(vlookup(...)),"default answer",vlookup(....))

If you're using xl2007, you could use:

=iferror(vlookup(...),"Default answer")

NANGO wrote:

I have quote spreadsheet in which sale rep can fill in a part number and the
description, price and type of item it is fills in automatically.

My question is, if they part number isn't in the vlookup table, I want a
default answer to fill in the type column instead of #N/A.

Is that possible, and if so, how would I do it?

Thanks

--

Dave Peterson