Issue with For Each Formula

[justinpeeler]

Hi, hopefully someone can help me with this issue.

I have a sheet setup basically like this:

Column A ... Column G
Plant1 $10
Plant9 $14
Plant1 $12
Plant12 $15
Plant5 $20
...
Plant10 $25

I want to loop down A14:A24 and check if any of the cells contain "Plant 1" through "Plant 7". If they contain any of those plants I then want it to
loop through G14:G24 and multiply the corresponding value in that row by 1.1

I have the following code so far:

Please Login or Register  to view this content.

It's working so far that it loops through both columns but instead of multiplying by 1.1 it seems to be multiplying by 2.85?

Any idea what could be causing this? I'm always open to recommendations to simplify the code.

Thanks.

[Miroslav R.]

Hi there,

this is the first thing I could think of and maybe I am not right, bu

You loop 10x over one cell and always multiple its value by 1.1.

I think that your initial value is 1.1
Then
1.1x1.1x1.1x1.1x1.1x1.1x1.1x1.1x1.1x1.1x1.1=2.85.

Check it for sure

[alansidman]

Deleted. Response was not relevant. I think that M.R. has it figured.

[stanleydgromjr]

justinpeeler,

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?

A14:A24 and check if any of the cells contain "Plant 1" through "Plant 7"

Your description above indicates that the plant name/type contains a space character.

But, your macro code indicates that the plant name/type are:
Plant1
Plant 2
thru
Plant 7

What are the correct plant names?

And, you only have to loop thru range A14:A24 to check the correct plant name, and, if found, do the math in G14:G24.

[justinpeeler]

And, you only have to loop thru range A14:A24 to check the correct plant name, and, if found, do the math in G14:G24.

This was my problem right there.

I removed the nested "For Each" so it only loops through column A then applies the math in column G and now everything is working correctly.

Thank you for the help!

[stanleydgromjr]

justinpeeler,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.