Excel 2007 : IF statement with VBA

[Endriuska]

Hi,

I don't have a lot of experience working with excel macros or VBA, but I understand how it works. Could anyone help me with this? It's is not complex, it just me because i dont know the syntax of VbA.
Here is what i need.

I have excel spreadsheet.

And A1:A10, is a TEXT for example A1="Blue..",A2="Green..",A3="Red..",A4="Red.."
And there is another column C1:C10, for example(numbers) C1="3.44",C2="4.55"....
And there are 3 cells, D1(blue),D2(green),D3(red).

I need something like this:

pseudo code

Please Login or Register  to view this content.

To make it even more clear, Ai = A + i = ex, A1,A2.. same with Ci, i is row number.

As you can see it is a very basic program, it basicly loops through the cells and if it finds what he is looking for it adds the number, which is in the same line it found it, fills with other text.

I don't except you to do it for me, but i would really appreaciate the example or a where to start.

Thank you

[pike]

Hi Endriuska
For starters try typing "Select Case" into a module , then highlight it and press "F1"
then look at "Cell" the same way
Your basic logic is OK you just need to add the expression syntax
Have a go and post your code