drag formula is not working

[primagic]

Hi,

I have the following formula in Excel.

{=INDEX('Market Ref'!E:E,MATCH(1,('Market Ref'!B:B=Data!F2)*('Market Ref'!A:A=Data!G2),0))}

When I try to copy the formula down it is retaining the reference to the first row. What do I need to modify in order to make sure it references the current row

Thanks
Andrew

 

[SkipVought]

Hi,

Have you calculated?

Was your formula range once TEXT?


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}