My VLOOKUP works fine how do I keep the cells from showing #NA when not in use.
T tankerman Dec 24, 2006 #1 My VLOOKUP works fine how do I keep the cells from showing #NA when not in use.
N Nick Hodge Dec 24, 2006 #2 Tankerman Wrap it in an IF(ISNA... combination =IF(ISNA(YourVlookup),"",YourVlookup) or if it's only to avoid blanks then just an if =IF(YouLookupCell="","",YourVLookip) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] www.nickhodge.co.uk
Tankerman Wrap it in an IF(ISNA... combination =IF(ISNA(YourVlookup),"",YourVlookup) or if it's only to avoid blanks then just an if =IF(YouLookupCell="","",YourVLookip) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] www.nickhodge.co.uk
