ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Find entries in one column in another (https://www.excelbanter.com/excel-programming/414612-find-entries-one-column-another.html)

Duguid1

Find entries in one column in another
 
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!!



NoodNutt

Find entries in one column in another
 
G'day

Checkout this, it will set you in the right direction.

http://www.rondebruin.nl/find.htm

HTH
Mark.




All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com