What relative row I'm in?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fedude - 10 Mar 2008 11:56 GMT

I have a large array (startingHoles). Next to te array I have a column
containing a formula This formula needs to know the relative row of the
array it's next to for use in the formula.

Here is the formula:

=HLOOKUP(weekNumber,startingHoles,5,FALSE)

The "5" in the formula above is the relative row it's next to. I'd rather
not have to edit every cell in this column to increment this number.

Looking for a better way.....

Reply to this Message

Pete_UK - 10 Mar 2008 12:18 GMT

If you want the 5 to become 6, 7, 8 etc as you copy the formula
across, then change it to:

COLUMN(E1)

This will become COLUMN(F1), COLUMN(G1), COLUMN(H1) etc, which will
evaluate to 6, 7, 8 etc as it is copied across.

Hope this helps.

Pete

> I have a large array (startingHoles). Next to te array I have a column
> containing a formula This formula needs to know the relative row of the
[quoted text clipped - 8 lines]
>
> Looking for a better way.....

Reply to this Message

fedude - 10 Mar 2008 12:38 GMT

BINGO. Thanks!

> If you want the 5 to become 6, 7, 8 etc as you copy the formula
> across, then change it to:
[quoted text clipped - 20 lines]
> >
> > Looking for a better way.....

Reply to this Message

Pete_UK - 10 Mar 2008 15:01 GMT

You're welcome - glad it worked for you.

Pete

> BINGO. Thanks!
>
[quoted text clipped - 24 lines]
>
> - Show quoted text -

Reply to this Message