VLOOKUP or IF(ISBLANK) formula?
I am trying to find a formula that will pull the information from the Building and reception level columns onto another sheet based on if the Assigned Receptionist column is blank. I'm not sure if this would be a VLOOKUP or an IF formula. Is this sort of function possible? Thanks for the assistance!
Answers
-
You can use both!
You can start with an IF function, in the logic use ISBLANK, if the logic returns true do one thing, if false do another. The "thing" could be the VLOOKUP (or INDEX MATCH).
But if the only need for the check on blank is so that nothing is returned if there isn't a match in the lookup, you could just use an IFERROR around the lookup.
Take a look at:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!