Hi Folks
A tad too complicated for me to explain here so please refer to the attached Sample Workbook.
Cheers
hammer
Hi Folks
A tad too complicated for me to explain here so please refer to the attached Sample Workbook.
Cheers
hammer
If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
No idea why I need Rep, other than feeling left out....
hi hammer. try these array formulas. in K1:
=IF(INDEX(Base!$D$3:$AM$6,MATCH(A1&B1&C1,Base!$A$3:$A$6&Base!$B$3:$B$6&Base!$C$3:$C$6,0),MATCH(H1,Base!$D$1:$AM$1,0)+4)>=5,"Yes","No")
in L1:
=IF(K1="Yes",INDEX(Base!$D$3:$AM$6,MATCH(A1&B1&C1,Base!$A$3:$A$6&Base!$B$3:$B$6&Base!$C$3:$C$6,0),MATCH(H1,Base!$D$1:$AM$1,0)+5),"")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi hammer,
I get slightly different results. Array-enter this in cell I2 and fill down.Then this in J2 and filled down.Formula:
Please Login or Register to view this content.Formula:
Please Login or Register to view this content.
Edit: I had to go back and review your upload. I understood I4 to have anticipated "No" (it doesn't), and from there interpreted all wrong. Apologies.![]()
Last edited by FlameRetired; 09-20-2015 at 03:22 AM.
Dave
All good folks-
Many thanks to you both for your solutions-
hammer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks