Hello,
I have the formula below:
=IF(OR(LEN(B2)=0,C2>0),"",IF(AND(VLOOKUP(A2,$A3:$D$99,4,FALSE)=D2,VLOOKUP(A2,A3:$D$99,3,FALSE)>0,B2>A2),"Possible",""))
It should bring back the result "possible" when C2 is negative and D2 (name) matches other D cells while B2 (date) is greater than the A cell (date) for the corresponding matched d cell also the corresponding c cell is positive.
But I think the formula is not incorporating b2> corresponding matched column a.
Thanks!
so do you need another Vlookup? It is difficult to understand what you are after without a sample. Please post a sample zipped sheet and show expected results.
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, please see attached.
I am not really sure what I need, could be a vlookup. Thanks again.
Maybe =IF(OR(B3 <= A3, C3 > 0, VLOOKUP(A3, $A$4:$D$99,4,FALSE) <> D3, VLOOKUP(A3, $A$4:$D$99, 3, FALSE) <= 0), "", "Possible")
hi Shg,
I tried the formula suggested, but I noticed that when I delete rows 47 to 99, it still gives "possible", since b2 is greater than any of row 2 to 46, there should be no match. How will the formula change if B2 should be less than any column A date to get a match, I might have said it wrong earlier.
Thanks again!
Originally Posted by shg
It's difficult to understand your logic....
What does "if b2 is greater than A for the matched d cell" mean? Do you mean A2 or do you mean a cell within range A47 to A99 that matches date in A2?F2 should only be "possible" if b2 is greater than A for the matched d cell, i.e. the matched cell should be from rows 47 to 99.
Please specify using cell references where a match occurs and what results we should see.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks