Find entries in one column in another

D

Duguid1

Hi,
I have been trying to figure out a solution to this problem for days now and
it is really bugging me...

I have two columns with descriptions in. One column is part of a 'catalogue
list' and one column is part of a 'things that have been ordered list'. For
each item that is ordered the buyer needs to decide whether the item which
they are ordering is on the catalogue or not. This is however not always done!

This is where I come in. It is my job to search the list of items that have
been ordered and using the description of the item (sometimes 10 words long)
decide whether it is already on the cataolgue. This can be very time
consuming and I was wondering if there was a VBA code which could speed up my
manual process by comparing the two descriptions columns and matching up
similar results.

An example could look like...

'Things that have been ordered list'
description
**msc Breaded Fish Fillet Squares 70g 1x36pk

'Catalogue list'
description
Fish fillets 1x36pk, 70g

Any help would be much appreciated...I am losing sleep over this!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Multiple Occurence Of Text In A Column 7
Finding Similar entries in one column in another 2
find values and add them 2
Table with two pick from list columns that need to vlookup each ot 1
Nextrow in another column 7
Compare Columns and Copy Data 1
Add/Subtract columns from tab to tab in same file 3
VBA Question (rookie issue) 7

Top