Hello Jacob / Yogi,

First off, thank you both for the posting back and for the codes.

I learned to use both sets of codes and I don't know what I missed here on Jacob's ... I pasted them to my ws but I could not get the function to work ..

Yogi -- Thanks; you understand exactly my question and the codes work nicely. However, I forgot to mention in my question that:

1. I'd like the target "J" to be "not" case sensitive and,

2. Is there any way to modify the codes so that when A1 is not equal to "J" then B1 and B2 should be blank. This way, I do not have to restrict myself to "N" or "E". In other words, here is my revised goal:

If A1 is equal to "J" (J should not be case sensitive)

B1 will be equal to 1.65 and B2 will be equal to 1.5

If A1 is not equal to "J"

B1 and B2 will be blank.

Again, thank you both, and I look forward to hearing from you.

Regards,

Nee