VLOOKUP with IF and IFERROR Formula
I need to figure out the VLOOKUP formula within the Barrier Management Survey Status Sheet to where IF the Services Completed is “Door Program” (within the Shared Services Program Survey sheet), and the Facility Name matches, to then pull in Survey Status “Complete”, otherwise (IFERROR) "N/A". This is the new formula I tried, but it’s coming back INCORRECT ARGUMENT: =IF(VLOOKUP(Services Completed@row, {Shared Services Program Survey Range 2}, 12, false) = "Door Program", VLOOKUP(Survey Status@row, {Shared Services Program Survey Range 2}, 3, false), "Complete"). Suggestions?
Best Answer
-
I figured it out! =JOIN(COLLECT({Survey Status}, {Facility Name}, [Facility Name]@row, {Services Completed}, [Services Completed]@row))
Answers
-
At the very basic level you are missing the square brackets [ ] around the column names. See if it works after the fix below,
=IF(VLOOKUP([Services Completed]@row, {Shared Services Program Survey Range 2}, 12, false) = "Door Program", VLOOKUP([Survey Status]@row, {Shared Services Program Survey Range 2}, 3, false), "Complete")
-
I'm still getting "UNPARSEABLE" - other suggestions?
-
I figured it out! =JOIN(COLLECT({Survey Status}, {Facility Name}, [Facility Name]@row, {Services Completed}, [Services Completed]@row))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!