Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference multiple cells
Hi all, I'm a new Excel user, I'm trying to create a taxonomy of
entities (within the Computer Science domain) and I would like a single entity (row) to have one of its records (cells) reference two separate cells elsewhere in the worksheet. Let's say one cell (F5) has the data: "testingA" And another cell (Z20) has: "testingB" then I would like my single cell to contain: "testingA and testingB" I was thinking about something like this: =$f$5 and $z$20 but that obviously didn't work. Thanks for any advice, Novice |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I reference multiple cells? | Excel Discussion (Misc queries) | |||
Multiple cells reference | Excel Worksheet Functions | |||
Replacing sheet reference in multiple cells... | Excel Worksheet Functions | |||
Populate multiple cells using the same reference | Excel Worksheet Functions | |||
Reference multiple cells in if statement | Excel Worksheet Functions |