Auto populate a cell by comparing lists
 

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

Auto populate a cell by comparing lists
 

On Jul 13, 9:05*am, Ken wrote:
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

Auto populate a cell by comparing lists
 

On Jul 13, 12:57*pm, recrit wrote:
On Jul 13, 9:05*am, Ken wrote:





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- 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