I have 2 tables, 1 with master data populated with "Restaurant", "State" and "Suburb" information. I have a second table with only the "Restaurant" data. Is there a function that will search and compare the 2 tables' "Restaurant" text fields, and if there is a match, populate the "State" and "Suburb" fields in the second table?
Restaurant State Suburb Restaurant State Suburb Julios - NY New York Manhattan Julios - NY
Last edited by gajerose; 11-27-2019 at 07:29 AM.
Hi,
Yes, you're talking about VLOOKUP, follow Attatched
Cheers!
John.
"I excel at jumping to conclusions"
Thanks! that did the trick
Glad I could help
- If your question is resolved, mark it SOLVED using the thread tools
and if you think I deserve reputation points, click on the star "Add Reputation"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks