Match and Index Help

[20did99]

I need help with Match and Index.

The problem is - I have a table I need the Index formula to copy down to each row. The problem I having is that the formula is copying down however, the array reference is moving down by one else well.

For example

Row 1 in my table will show =INDEX(Sheet1!A1:D6,MATCH(1,(Sheet1!A:A=G3)*(Sheet1!B:B=H3)*(Sheet1!C:C=I3),0),4)

Row 2 in my table will show =INDEX(Sheet1!A2:D6,MATCH(1,(Sheet1!A:A=G3)*(Sheet1!B:B=H3)*(Sheet1!C:C=I3),0),4).

Can someone help.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread:https://www.excelforum.com/word-formatting-and-general/1299639-match-and-index-help.html#post5245448