Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Reference
Novice excel user (just getting the hnag of formulas)
Have seen data charts where a number reference would recall txt in the cell next to it For example: putting the number "35" in cell A1 would porduce the name "John Doe" in cell A2 i know a list needs to be created on another sheet, or out of the print area of same sheet, but i do not know how to link it Would appreciate any help , would also like to know if ANY data such as numbe/letter combo can be used to recall data Thanks Stretch (Dan) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Reference
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Stretch_34" wrote in message ... Novice excel user (just getting the hnag of formulas) Have seen data charts where a number reference would recall txt in the cell next to it For example: putting the number "35" in cell A1 would porduce the name "John Doe" in cell A2 i know a list needs to be created on another sheet, or out of the print area of same sheet, but i do not know how to link it Would appreciate any help , would also like to know if ANY data such as numbe/letter combo can be used to recall data Thanks Stretch (Dan) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell reference within text? | Excel Discussion (Misc queries) | |||
How to convert text into range reference? | Excel Worksheet Functions | |||
How do I put text and a cell reference in a text box? | Excel Discussion (Misc queries) | |||
Reference date as text | Excel Worksheet Functions | |||
How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) |