Return Multiple Values in Smartsheets

Kedar Honrao

Hi all - I am trying to create a search box feature in Smartsheets. I have two sheets - 1) End User and 2) Main sheet where my data is stored.

The data sheet has several columns, and for this purpose, I am only interested in 4 columns - 1) Keyword (Drop Down), 2) Content (Text), 3) Status (Drop Down), and 4) Project (Drop Down)

Note: Keywords are repeating for some content, status, and project columns.

Purpose: In the End user sheet, if a user types in a keyword or selects a keyword from the drop-down, I want to display all the matching Content, Status, and Project cells.

I tried using VLOOKUP, but it will only return the first matching value; how can I get it to return all the matching values?

I appreciate any help you can provide.
Best,
Kedar

KPH

Do you want all the matching values in one cell? If so, you can use JOIN COLLECT.

Or do you want one per row? If so you will need another parameter, such as a row number, and use INDEX MATCH instead of VLOOKUP.