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

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

Hi 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

You need a VLOOKUP formula (or two). To understand how to use this, look at
my 'Excel Database' tutorial at
http://www.edferrero.com/ExcelTutori...0/Default.aspx

Ed Ferrero
www.edferrero.com