=if(isna(vlookup(...)),"",vlookup(...))
Then use conditional formatting that if the cells is equal to "", it's
shaded.
(Formulas can't change cell color)
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Gazivaldo" wrote in message
...
I'm using VLOOKUP to search for an exact match of a cell but when it can't
find a match it returns #N/A. Now, I KNOW, that there sometimes won't be
a
match but rather than returning #N/A is it possible for Excel to return a
blank, or better still a shaded cell??