This is a follow up to my last post about how to create a lookup table with user input with a results for each match.
I have come up with the user input, lookup table, and results. My issue is that it will only give me the results that it matches in B2 if they are EXACT matches.
What I need is something that will autopopulate in column G:G depending on the matches. (currently I have G2:G5) which should be sufficient but I don't want to leave room for error. I know that Partial matches are not a perfect science, but this will narrow the user's choices down and make their lives much easier.