Hello - when doing a VLOOKUP to return values, I would like the blank cells to return as blank (ie. not have a 0 or N/A filled in, just leave a blank). Please help me fix this formula to return the numbers when there are numbers, and nothing if it is blank. Thank you!
=VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)
try the formula
=IF(VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)=0,"",IF(ISNA(VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)),"",=VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)))
Thanks for the help - unfortunately I am getting an error message that the formula won't work. I found a space just before the last VLOOKUP and thought that was it, but it still won't work. Is there some ) missing? Thx again!
sorry
replace
=IF(VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)=0,"",IF(ISNA(VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)),"",= VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)))
with
delete "=" (red color), Being more exact, it is
=IF(VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)=0,"",IF(ISNA(VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)),"", VLOOKUP(C62,'Lookup'!$B$6:$F$2000,3,0)))
Last edited by tigertiger; 05-08-2011 at 01:24 AM.
It worked! Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks