Which function to use?

  • Thread starter Thread starter shortstopjmb
  • Start date Start date
S

shortstopjmb

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