Which function to use?
 

Hi. I am setting up a spreadsheet. One Sheet 1, I have a list of Descriptions
in cells A1:A30.

On another spreadsheet I would like to set up a function so that if I type
in "A1 or 1" in a cell, the data from cell A1 on sheet 1 appears.

Any help? Thanks.

Which function to use?
 

In Sheet2, put the number in A1 and in B1 put:

=INDIRECT("Sheet1!A" & A1)
--
Gary''s Student - gsnu200781

Which function to use?
 

Another one:

=INDEX(Sheet1!A1:A30,n)

Where n = the number of the item or a reference to a cell that holds the
number. For example:

=INDEX(Sheet1!A1:A30,5)

Sheet2 B1 = 5

=INDEX(Sheet1!A1:A30,B1)

Both of those will return the value from Sheet1 cell A5


--
Biff
Microsoft Excel MVP


"shortstopjmb" wrote in message
...
Hi. I am setting up a spreadsheet. One Sheet 1, I have a list of
Descriptions
in cells A1:A30.

On another spreadsheet I would like to set up a function so that if I type
in "A1 or 1" in a cell, the data from cell A1 on sheet 1 appears.

Any help? Thanks.