Entering data into a certain cell if another cell contains a certain field

[printwearclothing]

Hello,
I've attached this image so i can better explain my issue

What I am trying to achieve is this;
Column A corresponds to certain colours in which they need a certain URL entered into column CR in-line with the same row
For example
If a cell in column A contains the word "BLK" i need it to input text into the same row under column CR

If you can help me with this ill be very great full

[6StringJazzer]

To understand this, I need to know what "certain colours" and "certain URL" mean. How many different colors (sorry, I'm a Yank ) are there? What URLs are associated with them? Do you want the URLs in column CR to be hyperlinks, or just text?

Depending on what you need this could be solvable with formulas, or might require VBA.

[karan]

If the condition is satisfied, what kind of text do you want to put in Column CR?

Here, we can very conveniently use If and Find formulas. Kindly, post your exact requirement.

Regards,
Karan

[6StringJazzer]

Are there rules for formulating the SKU that dictate how the color is coded? For example, is it always the first three characters after the first underscore?

[6StringJazzer]

Here is a solution that assumes that the color is always three characters starting with the 6th character, and it assumes that the colors in your example are all the available colors. The result is a text URL, not a hyperlink.

If either assumption is wrong then the formula would have to be tweaked a bit, but this should be instructive.

[printwearclothing]

Are there rules for formulating the SKU that dictate how the color is coded? For example, is it always the first three characters after the first underscore?

Unfortunately it is not always a three character code for the colours, for example a code could be nv/bk
I need to make a condition to examine the SKU, something like wildcard,colour code, wildcard.

If the condition is satisfied, what kind of text do you want to put in Column CR?

Here, we can very conveniently use If and Find formulas. Kindly, post your exact requirement.

Regards,
Karan

I do not need a formatted html link, all I need is the text, for example http://www.websitename.com/images/colour.jpg

[6StringJazzer]

Unfortunately it is not always a three character code for the colours, for example a code could be nv/bk
I need to make a condition to examine the SKU, something like wildcard,colour code, wildcard.

What is the syntax for the SKU, then? Is the color always in between the first two underscores? I notice in one line there seems to be no color at all.