Excel formula help

New Contributor

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".



Screenshot 2022-08-11 14.47.48.png



Screenshot 2022-08-11 14.47.53.png



I hope this makes sense to you all.

Any help would be greatly appreciated.

4 Replies


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.

@Hans Vogelaar I tried that in all the appropriate cells but keep getting an error as below

Screenshot 2022-08-12 15.07.37.png

best response confirmed by Sergei Baklan (MVP)


Do you use comma as decimal separator? If so, replace all commas in the formula with semicolons.

@Hans Vogelaar That worked a treat. Thank's a million