if else formula for dynamic range

Hi,

i need help again for a formula to use in a dynamic range.

Emp Id Experience(yrs) Tenure
123 4.5 4-5 yrs
124 0.8 0-1 yrs
535 6 yrs > 5 yrs


Basically i have a dynamic range of emp Id and Experience, i need to write a formula to bring values like (0-1 yrs, 1-2 yrs, etc) in column Tenure.

for the below code (truncated all ifs and else to avoid clutter), error arises: object variable or with block variable not set

Please Login or Register  to view this content.

Thanks in advance,
Anjale

You need to 'Set' your ranges like you did with your worksheet

Please Login or Register  to view this content.

Try this untested code

Please Login or Register  to view this content.

I don't know what you are trying to point out

I am resetting sResult to none for each loop in the below code to avoid false result

Please Login or Register  to view this content.