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)

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)