Auto populate a cell by comparing lists

[Ken]

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

 

[recrit]

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

enter in column N on "JobLogEntry".
=VLOOKUP(M3, CustomerSurveyList, 2, FALSE)

M3 >> name selected in your dropdown / data validation list
2 >> column in 'CustomerSurveyList' to return

 

[Ken]

enter in column N on "JobLogEntry".
=VLOOKUP(M3, CustomerSurveyList, 2, FALSE)

M3 >> name selected in your dropdown / data validation list
2 >> column in 'CustomerSurveyList' to return- Hide quoted text -

- Show quoted text -

recrit, thank you so very, very much! The formula is EXACTLY what I
was looking for....getiing it implemented now! Again I appreciate the
help!
Ken