various values and listing them

D

donjuan66

Hello,

I am rather new to excel as I never have been really interested in i
since now.

At my work we use a program for our warehouse and it stores entries i
dbf files.

I get the tables in excel out of the dbf files but as this program i
sort of shitty(perdon my expression) it does have a mix of data in
few database tables.

I want to be able to use the provider number and list this in a exce
table extracting with it the product description and 3 other values.

Is this possible in excel and houw would I code that.

If someone could tell me the formula and I would try to put it in plac
in order to learn from it.

If you need more data I would try to write it.You just have to tell m
what kind of data you would need as I dont know what other data yo
need.

Thanks in advance.

best regards,

Mik
 
W

William Horton

Yes, we need some more information in order to help you out. Perhaps you
could list the various Excel tables you will be making out of these DBF file
and the fields that will be in them. Then list what you want to see in your
"answer" table.

If I have to take a guess at it though I would suggest looking into the
Excel VLOOKUP function. I'm guessing that you have multiple Excel tables
with a common field in each table (provider number). You then want to list
data from each table based on the provider number. The VLOOKUP function
would accomplish this.

If the tables are really big and depending what else you want to do with
this data, Microsoft Access may be a better software to use.

Hope this is a start.

Bill Horton
 
D

donjuan66

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
 
Top