Return a value if an item matches

Hello - new to formulas & struggling to get one to work.

I have two sheets: One with the values in column format (Payer CSS Responses by Initiative) - this was done so specific drop down options can be chosen; and one that contains those same columns but in row format so that it easy to view (Payer CSS Template).

What I'm looking to do is: Return the values in the columns from the first sheet into the row on the second sheet, but ONLY if the opportunity name matches. For example: if the opportunity name Empire (O123456) is on the Payer CSS Template, return the values from that row in from the Payer CSS Responses by Initiative.

I've figured out how to return the value by creating this formula, but I don't want to have to do this for every Payer CSS Template sheet once its created.

=INDEX({Payer CSS Responses by Initiative Range 1}, 1)

Thank you all for your help with this!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!