Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function to use?
In Sheet2, put the number in A1 and in B1 put:
=INDIRECT("Sheet1!A" & A1) -- Gary''s Student - gsnu200781 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |