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