how do i get execel to recognize unique values e.g receipt book #

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

Start by asking this question in the appropriate newsgroup:
microsoft.public.excel.worksheet.functions
--
Andre
Blog: http://adacosta.spaces.live.com
My Vista Quickstart Guide:
http://adacosta.spaces.live.com/blog...3DB!9709.entry
"techwiz101" <> wrote in message
news:584367F9-6ED3-433D-9163-...
> 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