If a value in a cell equals the same value in a column from another sheet


Hello Smartsheets team,

Hopefully a simple question, but I can't seem to get the right formula going for it. I'm just looking to see if the value in a certain cell from Sheet A (an invoice number) already exists in another sheet's column, Sheet B (essentially to prevent duplicate numbers). I've been trying with INDEX, MATCH but can't seem to find the proper way to write this formula. Would that be possible? Thanks in advance for any answers!

What I'm attempting:

If (value in Cell A) on (Sheet A) is equal to an identical value found in (Column A) on (Sheet B), then display the matching value from (Sheet B) in (Cell B) on (Sheet A).

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!