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

  • Thread starter Thread starter techwiz101
  • Start date Start date
T

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
 
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
Click to expand...

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

Ed Ferrero
www.edferrero.com
 
Back
Top