| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell on sheet 1 equals cell on sheet two
Hi,
Please use Vlookup for this. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Shane" wrote: When I calculate the value for eg: On sheet 1 where cell A1 equals cell A1 in sheet 2. that is no problem. Can sheet 1 cell A1 keep track of sheet 2 cell A1 if it is moved lower down in the row for example when sorting numbers from higher to lower and not just staying by A1 on sheet 2. thanks -- Shane A. Cawthorn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, how do I make a cell equals the sheet name? | Excel Worksheet Functions | |||
| If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc. | Excel Worksheet Functions | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
![Suleman Peerzade[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
