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

[#1]

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?

[#2 · Accepted solution]

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

[#3]

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