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

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
 
E

Ed Ferrero

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i get execel to recognize unique values e.g receipt book # 1
how do i get excel to recognise unique values eg badge # 1
How can I do amalgamate 3 select queries and then get unique entries from the result 2
How do I get Excel to make highest #, 1 color, & lowest # another? 1
How do I get Outlook to recognize commas in between address lists. 1
How do I get unique values from 2 columns? 2
How to Sort by Count the Max nos of Unique text values in Pivot Ta 1
How do I get Access to recognize duplicate values immediately? 13

Top