Conditional Output Loop testing values in one column & outputting in another

[bakeraj256]

Hi,

I have a column of numerical data in column H. I want to run a loop to test the value of the data in each row of the column.

For each cell, depending on the value, want output in column I of either "L", "M" or "H" (without the quotations). This is what I have rigged up so far, but I am doing something wrong with the offset function. Also if anyone has a suggestion for an easier way that would be cool too. Thanks

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[bakeraj256]

Excellent, this worked. Thank you so much. I used the first method.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.