Macro or formula to analyze data in a range for similar data in another range

Hi, I'm not even sure if this is possible but I'm hoping to find a way to have excel make a best guess and return the value in a dataset. Using the example below Excel would read the values in colum...