topic Re: How do I create a new column that will populate values from column 2 or 3 based on values from column1? in Discussions

How do I create a new column that will populate values from column 2 or 3 based on values from column1?

DegreesOfGen19 — Sat, 10 Jun 2023 23:55:38 GMT

I am trying to create a new column "Desired Column" that will combine columns "Sample1" and "Sample 2" depending on value from column "Group". Can anyone point me in the right direction for this?

Re: How do I create a new column that will populate values from column 2 or 3 based on values from column1?

KarenC — Thu, 20 Oct 2022 23:07:20 GMT

Perhaps the "Match" function will do the trick? In the formula editor Conditional > Match

Re: How do I create a new column that will populate values from column 2 or 3 based on values from column1?

DegreesOfGen19 — Fri, 21 Oct 2022 19:13:38 GMT

Thanks KarenC, that's exactly what I've been looking to find. It works prefect!