• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract Upper Case Characters from a cell and Match

I

Injinia

Member
Hello,

I have a set of data in one column in a master file as shown below in the sample

Product Code Product Name
1326 AMMONIUM, dry or wet
1327 AMMONIUM DH or AMMONIUM TH or AMMONIUM, LAB ZX
1328 AMMONIUM

I would like to compare data on my worksheet as follows:

If the product code is found on my worksheet, the formula should look up the product code in the master file and compare the names on my work sheet to those in the master file for an exact match.

Conditions for the check:

1- Only Upper Case letters = product name.
2- any characters after the Upper Case letters should be excluded from the check

AMMONIUM, dry or wet. The product name to be checked is AMMONIUM

3- If there are multiple instances of a product name in the same cell, separated by the word "or", the subsequent Upper case letters should also be considered example:

Product 1327 AMMONIUM DH or AMMONIUM TH or AMMONIUM, LAB ZX, has 3 different names which should all be looked up. either of the names is correct.

My worksheet contains only one product name although there may be multiple names in one cell on the master file.

Help on this much appreciated!
 
Uploaded the sample file. Don't mind the language is not english. some of the cells have the word "OR". This separates the data in the cell as either of the following AMMONIUM DH or AMMONIUM TH or AMMONIUM, LAB ZX, or AMMONIUM, dry or wet.

I would only need the product names and these are in capital letters. If a product name has a comma example AMMONIUM, LAB ZX, that is one product
 

Attachments

  • Chandoo.xlsx
    423.6 KB · Views: 13
Hi ,

Sorry for the lack of a response ; I am on vacation , and will not be able to reply for at least another week.

If I do manage to work on your file , I will upload the workbook with the solution.

Narayan
 
Hi ,

I am not clear on what you want to do.

For example , cells B34 and B35 have the following text :

RÄJÄYTYSNALLIT

What is supposed to be done with this ?

If you can work out the output for a few input data items , it may make things clear.

Narayan
 
NARAYANK991 said:
Hi ,

I am not clear on what you want to do.

For example , cells B34 and B35 have the following text :

RÄJÄYTYSNALLIT

What is supposed to be done with this ?

If you can work out the output for a few input data items , it may make things clear.

Narayan
Click to expand...
Hi,

Sorry for the delayed reply. I got this solved already. Much thanks.

-Injinia
 
You must log in or register to reply here.
Back
Top