| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get a cell value using another cells value
I have multiple worksheets. I want to get a cells value from one worksheet
based on the cell value of another E.g. Worksheet 1 Cell reference A1 contains B298 I want on worksheet 1 in cell reference A2 to contain the value in worksheet 2, Cell reference B298 Regards Chris |
|
#2
|
|||
|
|||
|
Chris,
put in cell a2 =indirect(a1) HTH Andi "Chris" wrote in message ... I have multiple worksheets. I want to get a cells value from one worksheet based on the cell value of another E.g. Worksheet 1 Cell reference A1 contains B298 I want on worksheet 1 in cell reference A2 to contain the value in worksheet 2, Cell reference B298 Regards Chris |
|
#3
|
|||
|
|||
|
Slight mod
=INDIRECT("Sheet2!"&A1) -- HTH RP (remove nothere from the email address if mailing direct) "Andibevan" wrote in message ... Chris, put in cell a2 =indirect(a1) HTH Andi "Chris" wrote in message ... I have multiple worksheets. I want to get a cells value from one worksheet based on the cell value of another E.g. Worksheet 1 Cell reference A1 contains B298 I want on worksheet 1 in cell reference A2 to contain the value in worksheet 2, Cell reference B298 Regards Chris |
|
#4
|
|||
|
|||
|
Ummm am i missing something,why dont you just type = Sheet2!B298 in cell A2?
-- paul remove nospam for email addy! "Chris" wrote: I have multiple worksheets. I want to get a cells value from one worksheet based on the cell value of another E.g. Worksheet 1 Cell reference A1 contains B298 I want on worksheet 1 in cell reference A2 to contain the value in worksheet 2, Cell reference B298 Regards Chris |
|
#5
|
|||
|
|||
|
Yes you are missing the fact that A1 might change to C298
-- HTH RP (remove nothere from the email address if mailing direct) "paul" wrote in message ... Ummm am i missing something,why dont you just type = Sheet2!B298 in cell A2? -- paul remove nospam for email addy! "Chris" wrote: I have multiple worksheets. I want to get a cells value from one worksheet based on the cell value of another E.g. Worksheet 1 Cell reference A1 contains B298 I want on worksheet 1 in cell reference A2 to contain the value in worksheet 2, Cell reference B298 Regards Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying cell references next to embedded cells in Word 2000 | New Users to Excel | |||
| Need to find the right-most cell value in a string of cells | Excel Worksheet Functions | |||
| Identify if a cell is referenced by other cells | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| How to add cells wiht the condition of the former cell. | Excel Discussion (Misc queries) | |||
Linear Mode
