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
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 93"]
<TBODY>[TR]
[TD]-500.000,00
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD]Banana Apple
[/TD]
[TD][TABLE="width: 704"]
<TBODY>[TR]
[TD]Data: 1 MANGOGrape 0000000 800,000.00 EUR something something</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]-800.000,00</SPAN>
[/TD]
[TD]Mango Grape </SPAN>
[/TD]
[TD][TABLE="width: 704"]
<TBODY>[TR]
[TD]Something your Ref: 8750ours R ef: TG0PPM000000743 500,000.00EUR zu Gunsten Banana Appl e VVA </SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[/TR]
</TBODY>[/TABLE]


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 [TABLE="width: 893"]
<TBODY>[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[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.