How do you get a value from a cell while looping through the cells of another column?

Hi all,

Self-taught Excel noob here. I've been trying to get something done that I just can't figure out how to even though I know it's simple but I'm still struggling a bit with VBA synthax and logic.

Say you have a spreadsheet with 3 columns A, B, C. A has strings, B has numbers and C has numbers too. So we'd have something like:

A B C
x 3 20
y 6 35
z 2 33

In my project, I'm looping through each cell in column C. What I want, is that when a number in C is, for instance >= 30, it goes and searches for the String in the same row in column A. I then want to use that string to put in an e-mail title.

There's no need to display the entire code so I'll just put the part that errors each time. I've tried loads of things (Offset etc.) but no go:

Please Login or Register  to view this content.

I don't know if it's explicit enough but the code is pretty straight forward, how do I get the string in column A when the value of Column C is >= 25?

Any help appreciated!

Hi Holger,

Thanks for the quick response. I'm however getting a Run-Time Error 1004 with either of your code?

I can post the complete code if needed, there might be something missing.

Awe-SOME! Thanks Holger, works perfectly. Don't worry about error raising code, really appreciate someone helping this quick !

I was sure I tried the Offset method and it didn't work, probably wrote it wrong .

Meh, anyways, thanks again!

@HaHoBe: My situation is more or less same as mentioned here. I tried the solution that you suggested above but it doesn't work for me, empty cell is not updated with other cell's value.

I'm sorry for hijacking this thread, I'm just so desperate right now.