An Error return other than #N/A with VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
=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
 
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??
 
Back
Top