Showing the nth figure from a list

[Lynxbci3]

Hi,

I have a list data in a column, and on a daily basis i need to mov
down the column to the next item of data. I have a calc that tells m
it is the nth item i need how do i them reference that to show in
cell?

The column is not a fixed length....

eg day 4 i need the 4th item

1234
1542
195487
12456 * This is the data i want to show on my sheet
18547


Thank

 

[Guest]

Hi

Have a look at the OFFSET function. It depends on how your data is laid out
as what arguments you need to use.

 

[Max]

If your column of data as posted
is in Sheet1, A2 down

In Sheet2
--------
Suppose A1 contains: 4

Put in B1: =OFFSET(Sheet1!$A$1,A1,)

B1 will return 12456 - the desired record

 

[Lynxbci3]

Many thanks, i have used the OFFSET and it is working well

Problem Solve

 

[Max]

Pleasure' Lynxbci3 !
Thanks for the feedback

 

[hgrove]

Max wrote...

If your column of data as posted is in Sheet1, A2 down

In Sheet2
--------
Suppose A1 contains: 4

Put in B1: =OFFSET(Sheet1!$A$1,A1,)

B1 will return 12456 - the desired record

...

OFFSET has its uses, and it can be used in this way, but INDEX would b
the better choice for this. Why? Note that Sheet1!A1 is *not* part o
the OP's data range, so many (most) users might not thing there'd b
anything wrong with inserting cells below Sheet1!A1 or moving (*cut
and paste) stuff into Sheet1!A1.

Whenever possible it's best to have indexed references into range
refer to those ranges. So the better formula would be

=INDEX(Sheet1!$A$2:$A$1000,A1

 

[Max]

Max wrote...
..

OFFSET has its uses, and it can be used in this way, but INDEX would be
the better choice for this. Why? Note that Sheet1!A1 is *not* part of
the OP's data range, so many (most) users might not think there'd be
anything wrong with inserting cells below Sheet1!A1 or moving (*cut*
and paste) stuff into Sheet1!A1.

Whenever possible it's best to have indexed references into ranges
refer to those ranges. So the better formula would be

=INDEX(Sheet1!$A$2:$A$1000,A1)

Thanks for insights, Harlan !