Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
An Error return other than #N/A with VLOOKUP
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?? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
An Error return other than #N/A with VLOOKUP
=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?? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
An Error return other than #N/A with VLOOKUP
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?? "Anne Troy" wrote: =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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |