Skipping cell

Try

=INDEX(12:12,(COLUMNS($A:A)-1)*2+86)

Don't change the $A:A reference, it's not related to your data.

12:12 is the row to return a value from.
*2 is the interval (every 2 columns).
+86 is the column to start with (Column CH is the 86th column)

It returns 0 values, no values.

Remember, the values on are the other worksheet.

Add the sheet reference to the 12:12 range reference..

=INDEX('Hrs Worked'!12:12,(COLUMNS($A:A)-1)*2+86)

It works for the first cell and fails for the rest, I think it might be the +86, the formula is continuously using this value, shouldn't it increment to the next column value?

It looks to be the Columns($A:A), it goes to Columns($A:B) and so on when I drag the fomula

It's working fine for me.

Originally Posted by jjbigfish

'Hrs Worked'
Cell CG12 is blank and CH12 has a value, CI12 is blank and CJ12 has a value, and so on. Basically every other cell has a value.


'Data Entry'
I want cell AU24 to hold the CH12 value, AV24 to hold CJ12 value and so on. Basically, how do I write the formula to skip the blank cell on the other worksheet and bring in the next value?

Here's a book doing exactly what you described..

EFjjbigfish.xlsx

I got it, it was me, I added more () where I shouldn't have.

Thank you very much for dealing with me.

You're welcome.