Using index to fill pattern

[roligankan]

Hello,

I want to be able to fill this formula horizontelly with this pattern

D5=IF(AND(Risks!N2=D3;Risks!O2=$D$1);Risks!A2;"")
E5=IF(AND(Risks!N3=E3;Risks!O3=$D$1);Risks!A3;"")
F5=IF(AND(Risks!N4=F3;Risks!O4=$D$1);Risks!A4;"")

And so on creating
G5=IF(AND(Risks!N5=G3;Risks!O5=$D$1);Risks!A5;"")

I suspect i should use the index formula but I can't seem to get it right

Could someone please take a look at this?

[XOR LX]

Hi,

Try this in D5 and copy across:

=IF(AND(INDEX(Risks!$N:$N,COLUMNS($D:E),1)=D3,INDEX(Risks!$O:$O,COLUMNS($D:E),1)=$D$1),INDEX(Risks!$A:$A,COLUMNS($D:E),1),"")

Regards

[roligankan]

Hi,

Try this in D5 and copy across:

=IF(AND(INDEX(Risks!$N:$N,COLUMNS($D:E),1)=D3,INDEX(Risks!$O:$O,COLUMNS($D:E),1)=$D$1),INDEX(Risks!$A:$A,COLUMNS($D:E),1),"")

Regards

Thank you, this was the solution to my question!

But unfortunely this I still have a problem. Should i open a new thread about this?

If you look at my attached document I will try to explain what i want to achieve:

In sheet "Risks" I want to write in which week and year a certain risk is in time.

If i would enter 10 in week and 2013 in year in the Risk ID A row, I would want this to show up in the time schedule sheet under week 10 2013 displaying A in the risk row.
Next i would enter week 15 and year 2013 in the risk id B row. This should then show up under week 15 2013 on the time schedule sheet.

How can i achieve this?

[XOR LX]

Hi,

You're welcome and yes, I believe you should open a new thread for this with an appropriate title.

Regards