LinkBack URL
About LinkBacks
Reinstated formula. See posts below.
Formula:
=IFERROR(INDEX(Offers!$A$2:$A$24,INDEX(MATCH(B2&C2&D2,Offers!$B$2:$B$24&Offers!$C$2:$C$24&Offers!$D$2:$D$24,0),0)),"")
Reinstated formula. See posts below.
Formula:=IFERROR(INDEX(Offers!$A$2:$A$24,INDEX(MATCH(B2&C2&D2,Offers!$B$2:$B$24&Offers!$C$2:$C$24&Offers!$D$2:$D$24,0),0)),"")
Last edited by DBY; 06-05-2015 at 12:55 PM. Reason: Reinstated formula.
The dates aren't relevant to matching the data at all, I believe this what you gave me is correct but I'll double check
Returning the first one is fine, I just want a system to show that an offer has been drafted for the Po that has come in. Returning with a bunch of offers would be over complicated for what I'm trying to do, when most of the time two offers wouldn't be created for the same company for the same amount.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks