Help with formula: return value from cell in same row if criteria is met
Hi, I am trying to figure out how to write a formula to return a value from the SAME ROW, when criteria is met. I can't figure out what I am doing wrong with index/match/collect  I am hoping someone can help! Most of the tips/tricks/Community answers I have seen are using columns not rows, so I am not sure how to do it. I index across sheets all the time, but this has me stumped.
Here is what I am trying to do: in a single row  if [Asset Type] contains X, return value from [X Link] @row; if [Asset Type] contains Y, return value from [Y Link] @ row…. and so on.
Asset Type is a multiselect drop down, so I will need to use a Contains function to find which asset type we are looking for, and bring in the appropriate link to that asset. Our links are in several columns based on the asset type.
We need to consolidate the links into a single column for an automation/integration we are working on, and with thousands of rows, we don't want to do it manually.
Can anyone help me figure this out?
THANK YOU in advance!
Answers

Have you tried nested If statements? An example of the formula could be =IF(CONTAINS("X", [Asset Type]@row), [X Link]@row, IF(CONTAINS("Y", [Asset Type]@row), [Y Link]@row, ….
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com

@AravindGP THANK YOU! It sure did  that is exactly what I needed. I am not sure how I missed that, but I sincerely appreciate your help!

@AravindGP I spoke too soon. It worked as long as it matches the first asset type in the formula, but then for any others (such as Asset Type Y) it returns #INCORRECT ARGUMENT SET.
Is there a way to fix that?

@Alyson Harris Are you able to share the entire formula you've used?
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!