# 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).

• ✭✭✭✭✭✭

You would use something like this:

=INDEX({Sheet B Column B}, MATCH([Invoice Number]@row, {Sheet B Invoice Number Column}, 0))

• ✭✭✭✭✭✭

You would use something like this:

=INDEX({Sheet B Column B}, MATCH([Invoice Number]@row, {Sheet B Invoice Number Column}, 0))

• Hello Paul,

That's perfect, thank you so much and for taking the time to answer! Works great!

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!