How would I get my VLOOKUP to return multiple Values?

Jerell Parker · 2021-03-16 23:58:06

Is there a way to get my VLOOKUP to return multiple values? Current Formula: =IF(ISBLANK([(REC) - Project Number]@row), "Part Number", IFERROR(VLOOKUP([(REC) - Project Number]@row, {QC1}, 3, false), "Part Number")) In my example image, there are 5 Project Numbers with unique Dates / Part Numbers / Part Descriptions / PO…

Answers

Paul Newcome ✭✭✭✭✭✭

11/15/23

@LakeWaconia Try a JOIN/COLLECT instead.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Odd bug in Date formula?
So here is something I have been trying to tweek with no success…. I have this column formula which takes the date in column A and gives me the updated date of same month, last day + 2 yrs (ie 11/01/24 becomes 11/30/26) =DATE(YEAR([Appointment Month]@row) + 2, MONTH([Appointment Month]@row) + 1, 1) - 1 and it works great…
IF formula with multiple options
Good morning- Wondering if someone might be able to help me with this. I have a dropdown list column that has three options. If option A is selected, I want to automatically populate another column in the sheet with a specific message, but if option B is selected, I want to populate that same column but with a different…
Index Join Collect - gather list
I want to create a formula that gathers a list of zones by identifying the area. Column A is the area, Column B are all the zones that are under each area. In the related form, the person enters Column A area and adds a zone to Column B that is under that particular area. As the list of zones builds with each form issued,…

How would I get my VLOOKUP to return multiple Values?

Answers

Help Article Resources

Categories