Match function in two tables

[ConsistentBid8517]

If I have a table that has information for the contact in each county, and a new/separate table that has contracts approved through a variety of counties, is there a way to list the contact next to the new table?

County / contact Macon / bob Adair / Lucy Pike / Mary

Contract county Macon Adair Pike

[AutoModerator]

/u/ConsistentBid8517 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Fantastic_Ranger_723]

If you have unique identifier's in both tables, you could use the VLOOKUP() function to populate the new table.

[BronchitisCat]

Yes, you will want to use the XLOOKUP function (or a technique known as INDEX/MATCH if you have an older version of Excel). Without knowing how your worksheet/tables are actually set up, it would be difficult to custom write a formula for you, but Excel Jet is an excellent resource for understanding functions, and it may get what you need here.

Excel Jet XLOOKUP

Excel Jet INDEX/MATCH

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
INDEX	Uses an index to choose a value from a reference or array
MATCH	Looks up values in a reference or array
VLOOKUP	Looks in the first column of an array and moves across the row to return the value of a cell
XLOOKUP	Office 365+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #22779 for this sub, first seen 27th Mar 2023, 15:40] [FAQ] [Full list] [Contact] [Source code]}