I have a list of names (which will change) in column B "data work
sheet". I'd like to assign a letter from colmun A to represent the cell
that each name is entered (a=B1). I'd like to use that letter to
identify the name to be used in the introduction of a generic message
on "message work sheet". I'd like to place that letter in a location
like C5 and have it reference the name.
Please advise the best way to do that and how to approach it. Help
appreciated.

Example:

"DATA WORK SHEET"

................ A..............B

1................a..........MR SMITH

2.................b.........TOM SMITH

3.................c..........TOM L SMITH

Enter "a" into cell C5

"LETTER WORK SHEET"

Dear (data work sheet, C5) MR SMITH


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=345805