If & VLOOKUP Formula

Catherine Williams
Catherine Williams ✭✭
in Smartsheet Basics

I am trying to do an IF function with a VLOOKUP referencing another sheet. I am trying to limit the amount of data entering so I want to automatically be pulling data. So IF Eblast is chosen I want it to pull information from "Content Schedule Sheet" for a particular property. If it could pull the date as well that would be great.

Any recommendations?

image.png image.png


· Share on FacebookShare on Twitter

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @Catherine Williams ,

    You need to get the sheets structured and syntax correct to produce the results you're looking for. VLOOKUP or Index/Match will let you find a value in another sheet based on criteria. I'm happy to assist but I need to better understand your sheets. What are you trying to look up and what criteria creates the match?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video