Hey NBVC do you know why =IF(LOOKUP($A2,Log!$B$2:$B$4,Log!$A$2:$A$4)=B$1,"Yes","No") wouldn't work for this? It seems to error out to 0 for 9/3/2011 but works for the others...
Hey NBVC do you know why =IF(LOOKUP($A2,Log!$B$2:$B$4,Log!$A$2:$A$4)=B$1,"Yes","No") wouldn't work for this? It seems to error out to 0 for 9/3/2011 but works for the others...
When helped,use the icon right of the post #.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks