Find products in cells against a table of products

S

stevepearson

I have a spreadsheet with variable data where i need to identify
specific products from a list of products in one cell, the list is
currently only around 12.

The cell i need to idnetify typically has betweem 2 & 30 products in,
mostly alphabetical with commas between them.

The list i am comparing against has one product in each cell.

I can make this work with 'Find' for only one product using the below
formular or for all the products, but cant seem to get it working when
i identify more than one product

=OR((FIND(N5,J13)),(FIND(N6,J13)))

Any ideas?
 

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

Identifying common data between 2 cells 1
Chose a product and update related product variables 0
Excel macro - search/find function 10
Find duplicate, save in a list, delete duplicate using macro 1
Drop down list control value in vba 2
macro to find a value and return another value on another workbook 3
Product ID 3
Identifying common data between 2 cells 1

Top