SOLVED

New Contributor

Excel formula help

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.

4 Replies

Re: Excel formula help

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.

Re: Excel formula help

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

best response confirmed by Sergei Baklan (MVP)
Solution

Re: Excel formula help

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

Re: Excel formula help

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