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

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/com...unts_passwords

Techwiz

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

http://www.microsoft.com/communities...excel.newusers

--

Ronnie Vernon
Microsoft MVP
Windows Shell/User


"techwiz101" <> wrote in message
news:0A67C358-2410-49A4-82AA-...
> 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/com...unts_passwords