Attempting to combine two lists

Don't use the first solution! There is an error other than the wild card that allows a false result for Road G.

Something in Row 9 of the Original List onward is not right and I can't find it right now. The corrections in YELLOW do work.

I suggest that you get rid of the word "Road" leaving just the letter. The use of helper columns like I have in this solution makes it much easier to work with and the formulae are somewhat less complicated as a result. The word "Area" could also be taken out for the same reason.

The areas in YELLOW, are areas that I changed. The formula has taken out the wildcard.