how do i get excel to recognise unique values eg badge #

[techwiz101]

how do i get execel to recognize unique values e.g receipt book # and pull
the relevant
information (text and number value) eg A cheque #15 , $120 was paid to
cover traveling expense. how can i put #15 in A1 and automatically get
Traveling Expenses in B2 and $120 in C3



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://windowshelp.microsoft.com/co...ndows.vista.administration_accounts_passwords

 

[Ronnie Vernon MVP]

Techwiz

Please post your message to an Excel newsgroup. Here is a link for those
groups.

http://www.microsoft.com/communitie...fault.aspx?dg=microsoft.public.excel.newusers