Aug 11 2022 07:05 AM
Hi All,
I am looking for some help in getting a formula right for the following scenario. Photo 1 contains a brief description of what I am trying to do, While photo 2 is a screen grab from "sheet4".
Sheet3
Sheet4
I hope this makes sense to you all.
Any help would be greatly appreciated.
Aug 11 2022 07:31 AM
In C5:
=IF(B5="Y", INDEX(Sheet4!$A$3:$A$25, COUNTIF($B$5:$B5,"Y")), "")
In E5:
=IF(D5="Y", INDEX(Sheet4!$B$3:$B$25, COUNTIF($D$5:$D5,"Y")), "")
In G5:
=IF(F5="Y", INDEX(Sheet4!$C$3:$C$25, COUNTIF($F$5:$F5,"Y")), "")
Fill down.
Aug 12 2022 07:10 AM
@Hans Vogelaar I tried that in all the appropriate cells but keep getting an error as below
Aug 12 2022 07:14 AM
SolutionDo you use comma as decimal separator? If so, replace all commas in the formula with semicolons.
Aug 12 2022 07:14 AM
SolutionDo you use comma as decimal separator? If so, replace all commas in the formula with semicolons.