I am using vlookup to return a restaurant name and time. Some of the restaurants don't have a time set and it shows up as "0:00" which I don't want to see. Is there an IF formula or something I can add in that will make "0:00" not show?
Here's the formula I'm using so far:
=VLOOKUP($A$2&" "&$B21,'[2012 Every Day (New).xlsx]Every Day (time redo)'!$A$4:$AW$999,36,FALSE)&"
"&TEXT(VLOOKUP($A$2&" "&$B21,'[2012 Every Day (New).xlsx]Every Day (time redo)'!$A$4:$AW$999,37,FALSE),"h:mm")
=IF(VLOOKUP($A$2&" "&$B21,'[2012 Every Day (New).xlsx]Every Day (time redo)'!$A$4:$AW$999,36,FALSE)&"
"&TEXT(VLOOKUP($A$2&" "&$B21,'[2012 Every Day (New).xlsx]Every Day (time redo)'!$A$4:$AW$999,37,FALSE),"h:mm")="0.00","",VLOOKUP($A$2&" "&$B21,'[2012 Every Day (New).xlsx]Every Day (time redo)'!$A$4:$AW$999,36,FALSE)&"
"&TEXT(VLOOKUP($A$2&" "&$B21,'[2012 Every Day (New).xlsx]Every Day (time redo)'!$A$4:$AW$999,37,FALSE),"h:mm") )
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks