VLOOKUP with IF and IFERROR Formula

Ashley Pierce

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?

Pic 1.png

Uploaded Mar 18, 202265.15 KB

PIc 2.png

Uploaded Mar 18, 202254.31 KB

Ashley Pierce

I figured it out! =JOIN(COLLECT({Survey Status}, {Facility Name}, [Facility Name]@row, {Services Completed}, [Services Completed]@row))

Sameer Karkhanis

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")

Ashley Pierce

I'm still getting "UNPARSEABLE" - other suggestions?

Ashley Pierce

I figured it out! =JOIN(COLLECT({Survey Status}, {Facility Name}, [Facility Name]@row, {Services Completed}, [Services Completed]@row))