How to pull information from sheet A to sheet B based on a dropdown selection on sheet B
I have two separate sheets. Sheet A contains job titles for a variety of different departments (Dept IDs). I need to pull all of the job titles from sheet A when a specific dept ID is selected in Sheet B's dropdown list. Any information will be greatly appreciated.
Best Answer
-
Thank you jmyzk_cloudsmart_jp. It worked. I was able to pull information from one column based off of Dept ID and positions. Would it be possible to pull several columns instead of just one?
Answers
-
Hi @RDRGSJ00
I would use the COLLECT function to get titles from Sheet A's Title range with Sheet A's Department ID range as a criteria range and Sheet B's [Department ID]@row as a criteria.😁
Example:
=JOIN(COLLECT({Job Title}, {Department ID}, [Department ID]@row), ", ")
Please take a look at the demo dashboard below.
You can edit Sheet A's [Department Name: ID] dropdown list and add new data to Sheet B to check how the formulas work.
-
Thank you jmyzk_cloudsmart_jp. It worked. I was able to pull information from one column based off of Dept ID and positions. Would it be possible to pull several columns instead of just one?