To avoid the #NA use something like
=IF(iserror(vlookup(A1, Z$1:AB$100,2,false)),"Not found",vlookup(A1,
Z$1:AB$100,2,false))

You can then use conditional formatting to highlight the cells containing
"Not found".

Tim

--
Tim Williams
Palo Alto, CA


"brutus" wrote in message
.net...
I have created a workbook for calculating commissions. I import invoices
from QuickBooks into a template that includes a table with inventory cost.
I need to know when an item that is imported is not on the table. Right
now
I use vlookup with the FALSE attributr to find cost and, as it should,
this
gives a #N/A error. I would like to instead change text color or the cell
background color in the cell with the incorrect item. I have looked
around
and cannot find how to do this. Any help? (I prefer to stay away from
VBA
if possible)

Dave