LinkBack URL
About LinkBacks
gnoke 
Do you mean?
=IF(AND(I21>1,I21<2),IF(ISNA(MATCH(A3+30,A21:A968,0)),A33,VLOOKUP(A3+30,A21:G968,2,FALSE)),"")
Do you mean?
=IF(AND(I21>1,I21<2),IF(ISNA(MATCH(A3+30,A21:A968,0)),A33,VLOOKUP(A3+30,A21:G968,2,FALSE)),"")
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.
Thanks for replays,
I was clearly not good enough to explain, my bad.
The cell D5 is a sample issue here. The rest #N/A is (as I you probably already understand) due to the limited date-sample here.
I see that A1 + 30 here looks after date 04.02.2007, since there is no such date in my sheet I would really like to get the value of the next date that exists, in this case the value of 05.02.2007 = 1.
Gnoke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks