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

Find more posts tagged with

Accepted answers

Paul Newcome

You would use something like this:

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

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.