Hi,

I have a formula below that I want to drag and also skip every other cell reference.

A2:=(IF(ISNUMBER(HLOOKUP(Sheet1!$C$10,'Sheet2'!$D$2:$O$1660,ROW(90:$1083),FALSE)),HLOOKUP(Sheet1!$C$10,'Sheet2'!$D$2:$O$1660,ROW(90:$1083),FALSE),0))/1000

So this formula basically looks up a value in row 90 from another her tab and tells me the value.

Now I want to drag this formula so that A3 and A4 and onwards look like this:
A3:=(IF(ISNUMBER(HLOOKUP(Sheet1!$C$10,'Sheet2'!$D$2:$O$1660,ROW(92:$1083),FALSE)),HLOOKUP(Sheet1!$C$10,'Sheet2'!$D$2:$O$1660,ROW(92:$1083),FALSE),0))/1000

A4:=(IF(ISNUMBER(HLOOKUP(Sheet1!$C$10,'Sheet2'!$D$2:$O$1660,ROW(94:$1083),FALSE)),HLOOKUP(Sheet1!$C$10,'Sheet2'!$D$2:$O$1660,ROW(94:$1083),FALSE),0))/1000

A5:=(IF(ISNUMBER(HLOOKUP(Sheet1!$C$10,'Sheet2'!$D$2:$O$1660,ROW(96:$1083),FALSE)),HLOOKUP(Sheet1!$C$10,'Sheet2'!$D$2:$O$1660,ROW(96:$1083),FALSE),0))/1000

Please help! I also can't use a helper column because I am not allowed to change the format of the sheet.

Thanks,