How to pull information from sheet A to sheet B based on a dropdown selection on sheet B

RDRGSJ00 · 09/08/23

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.

RDRGSJ00 · 09/20/23

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?

jmyzk_cloudsmart_jp · 09/09/23

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.

https://app.smartsheet.com/b/publish?EQBCT=f2df029f734b4727a7f789b311b44fdb

RDRGSJ00 · 09/20/23

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?

How to pull information from sheet A to sheet B based on a dropdown selection on sheet B

Best Answer

Answers

Categories