Hi Group!
Back again to ask another question. You have helped me
tremendously!
I have a worksheet named "JobLogEntry", and col M has a dropdown with
name selections from a named range from another worksheet named
"Lists". The named range is "Contacts". Would it be possible to
compare the name selected in the dropdown to another list of names
that reside on worksheet "CustomerSurveyList", cols A and B (with col
A being names, and col B being their tel ext and pager number) and
that range combined has a named range "CustomerSurveyList", and if the
dropdown name selected matches a name on that list, populate col N
("ext/pager" heading) on "JobLogEntry" with that name's ext/pager
number from col B, "CustomerSurveyList"?? If I've caused any
confusion, my apologies, but I'm the one who is most confused! Is
there any way to accomplish this task? Thanks in advance for any and
all help!
Ken