Create Lookup Table

M

Matt

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
 
G

Guest

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.
 
M

Matt

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.
 
G

Guest

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