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

Matt Desjardin

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

Paul Newcome

You would use something like this:

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

Paul Newcome

You would use something like this:

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

Matt Desjardin

Hello Paul,

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

Paul Newcome

Happy to help. 👍️