Forum Discussion
Solved
In desperate need of a formula for a -basically- simple task
I am building a test file in which to store test results but I am at a total loss. This is my problem: - Our products are sold in combination with 1, 2 or 3 accessories. - Products are manufacture...
Here is the tweaked formula...
=INDEX(Table1[[accessory 1]:[accessory 3]],MATCH([@product],Table1[product],0),IF(MOD(COUNTIF(F$3:F3,F3),COUNTA(INDEX(Table1[[accessory 1]:[accessory 3]],MATCH([@product],Table1[product],0),)))=0,COUNTA(INDEX(Table1[[accessory 1]:[accessory 3]],MATCH([@product],Table1[product],0),)),MOD(COUNTIF(F$3:F3,F3),COUNTA(INDEX(Table1[[accessory 1]:[accessory 3]],MATCH([@product],Table1[product],0),)))))
Please try this and see if this is what you were trying to achieve...
In H3
=INDEX(Table1[[accessory 1]:[accessory 3]],MATCH([@product],Table1[product],0),COUNTIF(F$3:F3,F3))
Subodh_Tiwari_sktneer This seems to be working 🙂 I still have to translate it to the actual file but if this works, you are truly a life saver! Thank you so much!