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,
Bookmarks