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