Spreadsheet: 321725d1401401038-partial-text-match-with-variables-sample-workbook-partial-text-match
Sheet: Sheet1

This set of data represents search criteria obtained by making selections in the main workbook. What I need is to look up the Certificate Number (if one is available) in the Certificate Master Database. In the real file, a certificate number won't always be available, but to simplify things I made this list from the Master Database, and every combination shown does have a certificate number. There may be duplicate certificate numbers, (I'm throwing this together quickly so I didn't check). Duplicate cert #s are ok, as long as there is a match. I have included the formula I was going to use below, but I am open to other formulas as long as they get the job done. This needs to be done with a formula, and no VBA, as the values in the left set can change constantly. I will also be using this across two workbooks, as the Master Certificate Database is too large to include in the main workbook. For now though, I would just like it to work on the same sheet -baby steps! |  |  |  |  |  | This set of data represents the Master Certificate Database of all certificate numbers on file. This data is obtained from an outside source, and is too numerous to correct manually (many thousands of lines, some of which will match multiple models).
A | B | C | Cert # |  |  | A | B | C | Cert #
RGRM-04EMAES278 | 13AJN30A01 | RCFL-AU3821CC |  |  |  | RGRM-04EMAES278 | 13AJN30A01 | RCFL-A*3821 | 6743531
RGFG-10EZCMS | 14AJM42A01 | RE50960 |  |  |  | RGFG-10EZCMS | 14AJM42A01 | RE50(6,9)60 | 7027779
RGFG-10EZCMS | 14AJM42A01 | RCFL-AU4821 |  |  |  | RGFG-10EZCMS | 14AJM42A01 | RCFL-A*4821 | 5732905
RGFG-10EZCMS | 14AJM42A01 | RCFL-AU4824 |  |  |  | RGFG-10EZCMS | 14AJM42A01 | RCFL-A*4824 | 5732907
RGFG-10EZCMS | 14AJM49A01 | RE36960 |  |  |  | RGFG-10EZCMS | 14AJM49A01 | RE36(6,9)60 | 7027818
RGFG-10EZCMS | 14AJM49A01 | RE50960 |  |  |  | RGFG-10EZCMS | 14AJM49A01 | RE50(6,9)60 | 7027819
RGFG-09EZCMS | 14AJM42A01 | RCFL-HM4824 |  |  |  | RGFG-09EZCMS | 14AJM42A01 | RCFL-H*4824 | 5732913
RGFG-09EZCMS | 14AJM42A01 | RCFL-HM4821 |  |  |  | RGFG-09EZCMS | 14AJM42A01 | RCFL-H*4821 | 5732909
RGFG-09EZCMS | 14AJM42A01 | RE36960 |  |  |  | RGFG-09EZCMS | 14AJM42A01 | RE36(6,9)60 | 7027770
RGFG-09EZCMS | 14AJM42A01 | RE50960 |  |  |  | RGFG-09EZCMS | 14AJM42A01 | RE50(6,9)60 | 7027771
RGFG-09EZCMS | 14AJM42A01 | RCFL-AU4824 |  |  |  | RGFG-09EZCMS | 14AJM42A01 | RCFL-A*4824 | 5732906
RGFG-09EZCMS | RAPM-030JAZ | RCFL-AU3824 |  |  |  | RGFG-09EZCMS | RAPM-030JAZ | RCFL-A*3824 | 4517849
RGFG-09EZCMS | RAPM-030JAZ | RE47936 |  |  |  | RGFG-09EZCMS | RAPM-030JAZ | RE47(6,9)36 | 4560544
A95UH2V090C20S | 4SCU16LT160P | AE50660 |  |  |  | A95UH2V090C20S | 4SCU16LT160P | AE50660 | 4907551
A95UH2V110C20S | 4SCU16LT160P | AE50660 |  |  |  | A95UH2V110C20S | 4SCU16LT160P | AE50660 | 4907552
A95UH2V135D20S | 4SCU16LT160P | AE50660 |  |  |  | A95UH2V135D20S | 4SCU16LT160P | AE50660 | 4907553
A80US2V070A12 | 4SCU18LS124P | EM1P30A |  |  |  | A80US2V070A12 | 4SCU18LS124P | E(C,M)1P30A | 5721435
A80DS2V090B16 | 4SCU18LS124P | EC1P30B |  |  |  | A80DS2V090B16 | 4SCU18LS124P | E(C,M)1P30B | 5721275
A95DF2V045B12S | 4SCU18LS124P | EM1P30B |  |  |  | A95DF2V045B12S | 4SCU18LS124P | E(C,M)1P30B | 5721668
A80DS2V090B16 | 4SCU13LE136P | EM1P36B |  |  |  | A80DS2V090B16 | 4SCU13LE136P | E(C,M,H)1P36B | 5721277
A95DF2V045B12S | 4SCU13LE136P | EC1P36B |  |  |  | A95DF2V045B12S | 4SCU13LE136P | E(C,M,H)1P36B | 4807523
A95UH2V045B12S | 4SCU13LE136P | EM1P36B |  |  |  | A95UH2V045B12S | 4SCU13LE136P | E(C,M,H)1P36B | 4807524
A95UH2V135D20S | 4SCU13LE148P | EC1P62D |  |  |  | A95UH2V135D20S | 4SCU13LE148P | E(C)1P62D | 4806778
A80DS2V110C20 | 4SCU18LS136P | EC1P62C |  |  |  | A80DS2V110C20 | 4SCU18LS136P | E(C,H)1P62C | 5721319