Create A Valid Circular Reference

Hey There,

I have a tricky one here. In a nut shell, I think I am trying to create a valid circular reference.

In Cell C102 is a list of peoples names and in D102 is a list of the employee numbers. What I am trying to set up is that if the user selects a name in C102, if populates the Employee Number in D102. If the Employee Number is entered, then it will populate the Employee Name on C102.

I tried this first, which created a citrcular reference and crashed:

Please Login or Register  to view this content.

I thought something along these lines might work, but no good:

Please Login or Register  to view this content.

Any help would be greatley appreciated!!
Thanx a million!!

Just realized I had a typo in the Range name. Corrected that (and above) but still getting the same error

That (unfortunatley) wasn't doing the trrick either. I am sure there is some pertanient detail that I don't know is important and am therefore not saying here to make the difference. However, I figured it out!! Used a sort of happy medium between what I learned from your examples abouve and my original approach - works liek a charm!

:D

Please Login or Register  to view this content.