How to drag a formula while skipping every other cell reference

**jhren** · 08-11-2013, 09:34 PM

Try...

Formula:

=(IF(ISNUMBER(HLOOKUP(Sheet1!$C$10,Sheet2!$D$2:$O$1660,ROW(INDIRECT((86+2*ROW())&":$1083")),FALSE)),HLOOKUP(Sheet1!$C$10,Sheet2!$D$2:$O$1660,ROW(INDIRECT((86+2*ROW())&":$1083")),FALSE),0))/1000

**sbham** · 08-12-2013, 04:33 PM

No that didnt work

How to drag a formula while skipping every other cell reference

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: How to drag a formula while skipping every other cell reference

Re: How to drag a formula while skipping every other cell reference

Thread Information

Users Browsing this Thread

Similar Threads

Drag and drop formula while skipping cells in the reference.

[SOLVED] Drag down range formula (skipping one row)

[SOLVED] Drag/Fill column while skipping multiple reference rows in another worksheet

[SOLVED] how to drag and copy a formula by skipping rows

How to drag reference formula down so it will change the sheet, but show the same cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions