How do I Link data from two tables

[iamkennyj]

I have a sample table for my vehicle inventory. It includes the collumns model, make, color and code. For every model, make and color vehicle there is a code assigned. For example a ford, focus, red can be assigned code #1. A ford focus, blue can be assigned code #2 and a chevy, camaro, yellow could be assigned code #9.

If I have another table from a third party that includes all of the same collumns except the code collumn, how can I automate the linking of the tables to assign the appropriate code to the third party table?

 

[Ruddles]

Hi and welcome to the board!

I suspect a simple VLOOKUP() function will probably do the job.

If you have any problems writing this yourself, post some sample data indicating clearly what the worksheet names are and which columns the data is in and I'm sure someone will help.

When posting data, place borders around the cells and select a fairly small font such as 8pt, then paste a few lines from each table directly into a message.

(Probably the best tool for linking tables in this way is MS Access.)

 

[iamkennyj]

Thanks