Formula - Copy data to remote cell

Ooops. Sorry my mistake in the explanation.


I don't think D2 can have the formula because it would need a nested IF that has 20 IF's and I think that exceeds the limit.

I have a row of 20 cells that contain different values (D5:W5)
Cells D6:W6 each have formulas that do something, but I would ALSO like it when the first one is true I want the value from the cell above it on Row 5 to go to cell Y5.


--A---B---C---D---E---F---G---H---I---J---. . . . . .---Y
1
2
3
4
5---------------1---2---3---4----------------------------1
6---------------T

------------^True^

If D6 = True then Y5 = D5 and End because this was the first occurance
Else If E6 = True then Y5 = E5 and End because this was the first occurance
Else If F6 = True then Y5 = F5 and End because this was the first occurance


So. If E6 is True AND G6 is true, I only want the value from E5 to go to Y5 because E6 was the first cell in Row 6 to be true.

If F6, H6, M6, R6 are each True, I only want the value from F5 to go to Y5 because F6 was the first cell in Row 6 to be true.


I hope that makes sense, and I hope there is a solution.

Thank you.

Thanks for your help.

And sorry for the long time that has gone by.


Your suggestion works indeed!

=INDEX($D$5:$W$5,MATCH($E$1,D12:W12,0))



Do you have any idea why these two matches don't work though.

=INDEX($D$5:$W$5,MATCH($E$1,D8:W8,0),MATCH($H$1,D8:W8,0))



Thanks so much for the help that we all get from you folks that know so much!