I've got an excel question that I'm struggling to find a solution to. For this solution I cannot use any macros/vba. Only formulas allowed because I need to export this to Xcelsius which doesn't support any macros/vba. Btw I can;'t use Row() in xcelsius too.
list of values                  list of string to match            final list
--------------                  -----------------------            ---------
 Car/Import/Automatic           Import                             Car/Import/Automatic
 Car/Import/Manual              Van                                Car/Import/Manual
 Car/Export/Blue                Manual                             Van/New/Imported
 Car/Export/Red                                                    Van/New/Locally
 Van/Used                                                          Van/Used
 Van/New/Imported
 Van/New/Locally
Any help/advise welcomed. Thank you very much!