Special VLOOKUP , 3 words search

The file looks as follows

Criteria

Formula on c1
LOOK UP D1 into B , if finds 3 words match , plug code on C

Trying to avoid reading since , they are not exact , but match somehow by 3 consecutive words

If the formula does it correctly it will plug on c1 and c2 the following

8411061788530
8411061677018

VBA again ..

Please Login or Register  to view this content.

John Topley it works beyond awesome , but it is only looking at the same line

It is not searching data the entire data , if you reverse the data d1 to d2 and d2 to d1 for testing

It checks column A for number of rows: is your data the same as your test?

It works OK on your test file: if I reverse D1 and D2 then C1 and C2 are left blank (correctly) as there is no "3 match". If add the original date into rows 3 and 4 I get the correct results in C3 and C4

I am going out for an hour or so and will respond when I return if still have problems. post a file ???

Here is the file with more rows , as that code worked for that data

I have jumbled the data so that it should go find where the code is

The file looks as follows the macro not running

1000 , rows , reading is long , still not VLOOKING UP as needed

Post back the file showing expected results: I assume if D matches a B then A corresponding to B row is put in C

Should the value from A correspond to that of row D?

Attached yellow belongs where and green belongs where

look up three words is good enough after second word , like TEAM FORCE ENERGISING

TEAM FORCE EDT is difficult , it can leave that blank , at least 80% of can be matched , remaining 20 percent I can read

If I am able to match by 80% , I only have to read around 400 rows out of the total 2000 lines

See attached:

You have to search to find maximum number of matching words otherwise you get erroneous results as pointed out in previous postings.

Yes it worked , blast , It did the crazy search , I am done case , thank you very much

Thank for the feedback.

Just one observation: can you be more explicit when defining your requirements to try and avoid me (and others) going down the wrong path!

Thank you.