Vlookup resulting in blank value

Hello, I am using VLOOKUP formula and need some assistance please.

I am searching "Primary Column" in one sheet and looking up that name on another sheet (within 2 columns CompanyName & AssociationName). This is the formula I am using

=VLOOKUP([Primary Column]@row, {Collectronics Export Source Sheet Range 1}, 1)

FYI, the #2 showing in PMC column I tried using MATCH formula not VLOOKUP. As you can see in PMC it is blank, any suggestions?

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!