Lookup for an ISBN number in Col A in Col B

[alldesineeds]

Hey Guys,

No familiar with VBA macros. Could anyone please tell me how to chk whether an ISBN is already existing in the file.
-ISBNs to be chked here are in Col A
-Description is there in Col B of which ISBN is a substring.

Please find attached file. Hope someone can tell exactly what needs to be done here.

Col A has approx. 7000 vals which need to be checked against 17500 vals in Col B. Hoping some expert can help here. Tysm.

Thanks,
sunny

 

[vletm]

alldesineeds
How many exist should be in that sample data? Any idea?
Rows from 1 to 6 are ... something.
But You could test this sample ...
Copy Your same kind of data
to Cols A and B
just as in Your sample
and
press [Check]-btn.

 

[alldesineeds]

Sorry wrong solution my frnd. Seems you did not understand the problem. Thanks

 

[vletm]

You couldn't answer my question ...
How many exist should be in that sample data?
Any idea?
That tries to find ColA ISBNs from ColB ... 'information'.
What do You want?
Could You show some sample answers?