Vlookup and return only if no match

I'm having trouble.

I want to do a cross sheet VLOOKUP and return the value from another column ONLY if its no match.

Details: I have a "HRC code" column and a "status in HHAX" column on sheets 1 and 2. If the code on sheet 1 matches code on sheet 2 then I want to get the status in HHAX value from sheet 2 ONLY if it doesn't match the status in HHAX value on sheet 1.

I hope that's clear and that someone can help me bc I'm sitting for the past 2.5 hours trying to figure it out.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!