Please help me troubleshoot the formula error in the attached file.
The goal here is to look at the values in column A, compare them to the values in column F, and if the values in column F are found within the values in column A, return the value in column G.
The formula is in column B, but it's not working.
I put the expected outcome in column D for reference.
Bookmarks