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

"donjuan66" wrote:


Hello,

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

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

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

I want to be able to use the provider number and list this in a excel
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 place
in order to learn from it.

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

Thanks in advance.

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