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
+-------------------------------------------------------------------
 
Top