Writing formula for IF(AND(CONTAINS with a VLOOKUP.


This is the formula I have come up with so far.

=IF(AND(CONTAINS(SO@row, {Sales Order Number}), CONTAINS(Part@row, {Unit Part Number})), IFERROR(VLOOKUP(Part@row, {VLOOK Part Pass/Fail}, 4, false), ""), IF(AND(CONTAINS(SO@row, {Sales Order Number}), Part@row = ""), IFERROR(VLOOKUP(SO@row, {VLOOK Pass/Fail}, 3, false), "")))

I am currently trying to work this formula to display what is stated in my "Pass/Fail" column on my Remote Sheet onto my Main Sheet based on unique "Sales Order" numbers and also the "Unit Part Number"

In picture 2 of my Main Sheet it is tracking the very first entry from my Remote Sheet as a "Passed with sign off" even though the "Sales Order 2" number does not match the "SO" number on my main sheet. "918FY" on my Main Sheet should read "Passed" like the "Pass/Fail" column states on the Remote Sheet. The Unit Part Number "HSAN-10-F" is the unique part number I am trying to track, it seems as though my Main Sheet grabs the very first "HSAN-10-F" it sees on my Remote Sheet and it displays what is in the "Pass/Fail" column for all of them on my Main Sheet.

Just wondering if anyone had any insight on my possible issues, I feel like it is something fairly simple that is holding me up.

Thank You All!!!

Remote Sheet

Main Sheet With Formula Below

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!