| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
worksheet reference returns address instead of value
I'm "pointing to" a cell in another worksheet. I should be able to hit "="
then click on the worksheet and cell I want, then hit enter. The value in the referenced cell should now show in the new worksheet. Instead, I'm seeing the address of the referenced cell. Has anyone had this problem? Is there possibly something in the formatiing of the two worksheets that's causing a problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup reference a worksheet | Excel Worksheet Functions | |||
| Using cell contents to reference worksheet names | Excel Discussion (Misc queries) | |||
| Indirect and Address in Reference to other sheets | Excel Worksheet Functions | |||
| Construct address as a reference not "text" | Excel Worksheet Functions | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
Threaded Mode
