That is because Vlookup found a match and the corresponding cell in the 14th column is sometimes blank, but Vlookup returns 0 when that is the case... and adds the 1...
Try:
=IF(OR(P2=1,P2=2,P2=3),IF(OR(ISNA(VLOOKUP(D2,QTR1_2011,14,FALSE)),VLOOKUP(D2,QTR1_2011,14,FALSE)=0),"",(VLOOKUP(D2,QTR1_2011,14,FALSE)+1) ),"")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That did it! Again Thanks so much.
You probably have a long list of (I owe you) lunches, so I'll offer a dinner.
While you have the attachement, notice the errors in the blank cells in columns O, P, Q down around rows 190. They disappear when data is populated..... is there a way I can get rid of those? It tells me those cells are the wrong data type, but I can't seem to find a fix. Its not a deal breaker, but would clean things up alittle.
Thanks NBVC, you have a great day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks