Hi,

This worked for me in the one cell I started with but when I attempted to drag this formula down on my own risk register the array's changed to move across one additional cell. So within your own formula below where I want the bold parts to change accordingly the italic parts would need to remain fixed but this is not the case for me....

=INDEX(sheet1!B3:F6,MATCH([C2,sheet1!A3:A6,0),MATCH(D2,sheet1!B2:F2,0))

My formula is turning into this:

INDEX(sheet1!B4:F7,MATCH(C3,sheet1!A4:A7,0),MATCH(D3,sheet1!B3:F3,0))

The lookup value is changing to what I want it to but the array change results in the formula returning an N/A.