Create Lookup Table
 

Hi,
I want to export item information from my database (i.e. which items were
sold for a certain time period) I want to then import that information into
Excel. What I am looking to do is set up a template where I create an item
line in Excel with full description of cases, U/M, size etc, and when I
import data from my database it will look at the item number and fill in the
rest of the line. Does anyone know how to accomplish this?

Thank You,
Matt

Create Lookup Table
 

Hi

One way of doing this is to use a VLOOKUP function on whichever column is
common to both sets of data (part number?). If you post a sample layout (in
plain text), we can advise you further.

Andy.

"Matt" wrote in message
...
Hi,
I want to export item information from my database (i.e. which items were
sold for a certain time period) I want to then import that information
into
Excel. What I am looking to do is set up a template where I create an
item
line in Excel with full description of cases, U/M, size etc, and when I
import data from my database it will look at the item number and fill in
the
rest of the line. Does anyone know how to accomplish this?

Thank You,
Matt

Create Lookup Table
 

Hi Andy,
Thanks for the response.

But the VLOOKUP would be used after I create the template right? How do i
create the temlate? Just put all the products and description in a regular
Excel page. Do I need to include certain formulas? An example of what a
line would look like.

45678 creamy peanut butter 20/40oz CS

Like 4 - 6 fields. All I would extract from my database would be the item
number.

Thanks.

"Andy" wrote:

Hi

One way of doing this is to use a VLOOKUP function on whichever column is
common to both sets of data (part number?). If you post a sample layout (in
plain text), we can advise you further.

Andy.

"Matt" wrote in message
...
Hi,
I want to export item information from my database (i.e. which items were
sold for a certain time period) I want to then import that information
into
Excel. What I am looking to do is set up a template where I create an
item
line in Excel with full description of cases, U/M, size etc, and when I
import data from my database it will look at the item number and fill in
the
rest of the line. Does anyone know how to accomplish this?

Thank You,
Matt

Create Lookup Table
 

Hi
Any format of template would be fine - as long as it does the job for you!
Make sure that the 'common' field is in the first column - it makes it
easier for the VLOOKUP formula. You need to use it as a reference point.

Andy.

"Matt" wrote in message
...
Hi Andy,
Thanks for the response.

But the VLOOKUP would be used after I create the template right? How do
i
create the temlate? Just put all the products and description in a
regular
Excel page. Do I need to include certain formulas? An example of what a
line would look like.

45678 creamy peanut butter 20/40oz CS

Like 4 - 6 fields. All I would extract from my database would be the item
number.

Thanks.

"Andy" wrote:

Hi

One way of doing this is to use a VLOOKUP function on whichever column is
common to both sets of data (part number?). If you post a sample layout
(in
plain text), we can advise you further.

Andy.

"Matt" wrote in message
...
Hi,
I want to export item information from my database (i.e. which items
were
sold for a certain time period) I want to then import that information
into
Excel. What I am looking to do is set up a template where I create an
item
line in Excel with full description of cases, U/M, size etc, and when I
import data from my database it will look at the item number and fill
in
the
rest of the line. Does anyone know how to accomplish this?

Thank You,
Matt