Based on http://www.excelforum.com/newreply.p...reply&t=700714 and...

Trying to apply these formulas for an automotive part list comparison for 2 different product providers, will need assistance for the following:
Provider1: Auto part table "A" contains a list with Individual years for each car make
Provider2: Auto part table "B" contains a list with GROUPED years for each car make

Based on what table "B" grouping issue, is there a way to look up for < = > year values?

Provider1 / Table "A"
Volkswagen Jetta 1996
Volkswagen Golf 1997
Volkswagen Jetta 1997
Volkswagen Jetta 1998


Provider2 / Table "B"
VOLKSWAGEN JETTA 1999-2002 6 Cyl - 2.8L [AFP]
VOLKSWAGEN JETTA 1994-1998 6 Cyl - 2.8L [AAA]
VOLKSWAGEN JETTA 2003-2004 6 Cyl - 2.8L
VOLKSWAGEN JETTA 2008-2010 5 Cyl - 2.5L

Thank you