Text Reference

[Stretch_34]

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)

 

[T. Valko]

See this:

http://contextures.com/xlFunctions02.html