If & VLOOKUP Formula


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?


  • 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?


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