Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
How can I return a value in one column from another sheet based on two inconsistent string criteria?
Hi, any help with this will be hugely appreciated.
On my master sheet I have a "Task Name" column, an "Audience" column and a "Description" column I want to populate with this formula.
On the source sheet I have a "Task Name" column, an "Audience" column and the "Description" column I want the data from.
Unfortunately, the text strings in "Task Name" and "Audience" will not always exactly match across the two sheets but the strings will definitely be there in some form, e.g. "US users" in the source sheet will be "US" in the master sheet.
I have tried VLOOKUP with multiple criteria but due to the slightly different strings it didn't work. Is there a way I can nest functions within the VLOOKUP to get the data from the "Description" column?
Another problem with this US example is that the word Russia also contains US.
I want it to be a column formula also, as editing the formula for each cell isn't possible due to the size of the sheet.
Please let me know if you need any other information. Thank you
Answers
-
-
Hi @Paul Newcome , apologies for the delay.
I've included some screenshots of some dummy data. As you can see the tasks may be related to the same thing but slightly differently worded. I guess this would require a different formula for each one so it's not really efficient, right?
I think maybe my best course of action here is to assign a unique Task ID to each task, in this example Row 2 on each sheet would have the same Task ID, and use that in a VLOOKUP with a single criteria. Does this sound like a more straightforward way of going about this?
Thanks a lot again
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!