pull information if columns match

Hi smartsheet community!

I would like to pull a value into a sheet from another sheet if the email address matches

sheet 1: source sheet

if 'email address' on sheet 1 matches 'created by' on sheet 2, I would like to pull the field 'Name' into sheet 2

=IF({2024 L&D Budget Source Range 1} = [Created By]@row, {2024 L&D Budget Source Range 2})

I tried above formula and it returned invalid operation

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 05/30/24

    @BrigitteM

    In Sheet 2.

    =INDEX({Name ref}, MATCH([Created By]@row, {Email ref}, 0))

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 05/31/24

    @BrigitteM

    Or you could just copy and paste this based on the references you posted.

    =Index({2024 L&D Budget Source Range 1}, Match([Created By]@row, {2024 L&D Budget Source Range 2}, 0))

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!