Thanks for your reply.

Indeed the tables are big but i need it done in excel as the result
will be send to the provider so that he can send us the material we
need.

I have

*Command sheet - this one will be send to provider and needs to list
his products by introducing the provider code.
* prov sheet - this one is the providers db
*mar sheet - this one lists provider code, products
*mad sheet * lists products, total in warehouse and maximum command.


as you can see our program uses lots of tables and it is real messy.

I need to list in command sheet the following information.

By entering the code of the provider the command sheet lists

Only the products of the provider, total in warehouse and maximum
command.

Youve told me about Vlookup.

I have already a formula with it but i dont know how to make it list
all cells with the same provider code.

Well I hope you could help me out.

Thanks again for your help.

Best regards,

Mike


--
donjuan66
------------------------------------------------------------------------
donjuan66's Profile: http://www.excelforum.com/member.php...o&userid=28676
View this thread: http://www.excelforum.com/showthread...hreadid=484240