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
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!