Match Insert

[dghyson]

I have two worksheets. One has a project Code with corresponding reference codes in the cell to its right. Altogether there are several hundred project codes and about five corresponding reference codes which match. (More than one project code can match a single corresponding reference code but only one corresponding reference code can match a Project code, one to many relationship.) In another table/worksheet I have a list of Project codes where the corresponding reference code fields are blank. How do I populate the corresponding reference codes into the second worksheet according to the first worksheet? Thanks.

 

[hiker95]

dghyson,

Welcome to the MrExcel forum.

It would help if we could see your actual raw data worksheet, and, what the resulting worksheet (manually formatted by you) should look like.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[FDibbins]

Without seeing some sample data, take a look at the VLOOKUP function.

=vlookup(what-you-want-find, range-to-search-in, column-to-return-value-from, 0)...the 0 makes the formula look for an exact match
=vlookup(A2,$J$2:$K$500,2,0)
This will search for an exact match for the contents of A2, in the rangeJ2:J500 (yes, I did mean to use both J's), and return the contents in the corresponding 2nd column (k)