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.
|