The file looks as follows
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
See attached:
I misunderstood that it needed to compare each entry against all entries in D.
Questions: what is volume of data (rows) in your "production" file? And number of entries in column D same as A?
Last edited by JohnTopley; 12-04-2015 at 12:22 PM.
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
Quang PT
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks