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 [email protected], {Shared Services Program Survey Range 2}, 12, false) = "Door Program", VLOOKUP(Survey [email protected], {Shared Services Program Survey Range 2}, 3, false), "Complete"). Suggestions?


Best Answer

  • Ashley Pierce
    Ashley Pierce ✭✭✭✭✭✭
    Answer ✓

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

Answers

  • Sameer Karkhanis
    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
    Ashley Pierce ✭✭✭✭✭✭

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

  • Ashley Pierce
    Ashley Pierce ✭✭✭✭✭✭
    Answer ✓

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

Help Article Resources