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?
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives