Auto populate a cell by comparing lists

  • Thread starter Thread starter Ken
  • Start date Start date
K

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
 
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
Click to expand...

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
 
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 -
Click to expand...

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