Muti-result for lookup function

R

rcc03461

I am trying to crate Inventory Excel for record stocks

1, I found a problem that excel cant show different location when th
location has same amount Qty.

2, how can i type the order number in B2 and excel auto show the item
request by the order.

3, Can anyone help me to improve my excel design? since i am not good a
database

Thank you for your help

:
Sherloc

+-------------------------------------------------------------------
|Filename: Inventory.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=634
+-------------------------------------------------------------------
 

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

State Tax Business Calculations Help 1
Lookup value across multiple columns and rows 0
Multiply with Vlookup value from another Worksheet 0
Condtional Formatting or LOOKUP ? 1
Index Match function for lookup HELP 5
Multiple Criteria Lookup 3
Excel function needed 24
display Column Header based on cell value in a range 2

Top