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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Match Insert
- Thread starter dghyson
- Start date
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
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
Upvote
0
FDibbins
Well-known Member
- Joined
- Feb 16, 2013
- Messages
- 6,723
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)
=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)
Upvote
0
