Multi Lookup Please Look

M

Martin_Cross

well i need help reli it for college and very important what i need to
do is select a type from the invoice n then from the list i want it to
lookup all the item with that type many thanx martin_cross

4544

4545


+-------------------------------------------------------------------+
|Filename: 4.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4545 |
+-------------------------------------------------------------------+
 
B

Bernie Deitrick

MArtin,

You can either use filters on your database: - Data / Filter... Autofilter... and select your
invoice number from the dropdown, or use a pivot table. The filter would be best.

HTH,
Bernie
MS Excel MVP
 

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

Custom Autonumber with Prefix and Category Grouping 3
please help: find nonblank cell in group of cells... 2
Manually Calculating Formulas - Resetting totals to zero 1
Please I Need Help 1
Combining Multiple Schedules into One Schedule 0
Creating sheets with pasted colour-marked rows through a nifty macro command, please 1
excel help 5
Multiply columns and sum row? 7

Top