An Error return other than #N/A with VLOOKUP

[Gazivaldo]

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??

 

[Anne Troy]

=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]

Thanks Anne. I've applied your formula and now I'm receiving a blank cell
which is great. However, for some reason the conditional formatting isn't
working. I've done exactly as you've suggested but it doesn't format any of
the blank cells. Any ideas??