Multiple Criteria search in a Text String

[Kromenad]

Hi all,

after searching all through the forums and posts I could not find a solution to the following problem:

I have 2 columns ,A and B, in a table and text strings in C. Each table row A1 and B1 needs to be compared and matched with the text string C:C. Only if both, A1 and B1, are found in the same string, say C5, it has to return A1&B1. If not, return "Not Found".

Several Obsticles:

1. A and B are text and number
2. C is text with different numbers saved as text and words all mixed up
3. There is no defined format for the text, it is different in each string

A	B	C
-500.000,00 <TBODY> </TBODY>	Banana Apple	Data: 1 MANGOGrape 0000000 800,000.00 EUR something something</SPAN> <TBODY> </TBODY>
-800.000,00</SPAN>	Mango Grape </SPAN>	Something your Ref: 8750ours R ef: TG0PPM000000743 500,000.00EUR zu Gunsten Banana Appl e VVA </SPAN> <TBODY> </TBODY>

<TBODY>
</TBODY>

With all these different formats and inconsistency, is it even possible?

I would really appreciate your help, cos I have been sitting on it for days now.

Thanks

</SPAN>

<TBODY>
</TBODY>

 

[Kromenad]

I have been using this formula for 1 criteria search

=IF(ISERROR(VLOOKUP(A1,C:C,1)),""Not Found"",A1)

but is does not seem to work when searching number or 2 different criteria

 

[Kromenad]

Hi all,
just wanted to let you know, in case somebody is dealing with the same problema as I did, that I ended up using the Fuzzy Look Up add-in from Microsoft. Works perfectly.