Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create a formula that when I type a number in that cell it will to
I am trying to create a formula that when I type a number in that cell it
will to another page and go to the column #(which is the number Ive typed in) and bring back the value and place it in another cell. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create a formula that when I type a number in that cell it will to
If you only give it the column #, it does not know which row in the column to
select. Let us then give the formula two values, the column letter and the row number. In A1 enter: AA In A2 enter: 100 =INDIRECT("Sheet2!" & A1 & A2) This formula will go to Sheet2, then go to column AA, then go to row 100 and retreive the value. -- Gary''s Student - gsnu200778 "highland" wrote: I am trying to create a formula that when I type a number in that cell it will to another page and go to the column #(which is the number Ive typed in) and bring back the value and place it in another cell. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create a formula that when I type a number in that cell it will to
Hi Highland:
You could try using offset on the cell where you want the answer. So if the data entry is in cell a1 on sheet sheet1 and the answer is in a2 put =OFFSET(Sheet2!A1,0,Sheet1!A1-1). Remeber that the offset uses first cell as 1,1 so here you need to deduct one. This works if the sheet is in the current workbook. If it is not then try the index function: =INDEX('C:\Documents and Settings\Dad\My Documents\[Book2.xls]Sheet2'!$A$1:$M$1,0,Sheet1!A1) This works on closed books. -- Hope this helps Martin Fishlock, NYF Consultants, Bangkok, Thailand Please do not forget to rate this reply. "highland" wrote: I am trying to create a formula that when I type a number in that cell it will to another page and go to the column #(which is the number Ive typed in) and bring back the value and place it in another cell. Any help would be appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create a formula that when I type a number in that cell it will to
Highland --
Here's something that worked for me. My workbook had a worksheet named 'Location', so substitute the name of your source worksheet to fit: =INDIRECT("'location'!" &"R" & 1 &"C" & D1,FALSE) where Location is the name of the worksheet 1 is the row where the data will be D1 is the where you'll type the column number you want to extract. HTH "highland" wrote: I am trying to create a formula that when I type a number in that cell it will to another page and go to the column #(which is the number Ive typed in) and bring back the value and place it in another cell. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with week number/day type formula | Excel Discussion (Misc queries) | |||
can i type a number for a specific name to appear in the cell? | Excel Discussion (Misc queries) | |||
How do I create a certain type of Excel formula? | Excel Worksheet Functions | |||
The number I type in a cell, e.g. 500, appears at 0.5 - why? | Excel Discussion (Misc queries) | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) |