INDEX/MATCH vs. VLOOKUP between two sheets

I have two sheets with identical columns - Market Name and Organization Name. I'm using dropdowns in these columns since I have external folks reporting into a form and I want the names to match across my entire workspace.

I want to copy Organization Name from one sheet to the other, and match on the Market Name. I feel like this should be simple, but I've tried using VLOOKUP and INDEX/MATCH and I am having trouble getting either to work. I use VLOOKUP in excel frequently but I think I'm missing something here in Smartsheet. Based on other similar threads, it also seems like INDEX/MATCH might be the better way to go. Screen shots below for reference.

Sheet 1 (where I want to put the formula in the Organization Name column). This is currently filled in with made up sample information, but eventually will have lots of rows of data from all of the organizations I work with.

Sheet 2 (I want to pull the Organization name from this sheet, matched on Market Name)

Find more posts tagged with

Formulas

Accepted answers

All comments

AravindGP

Hi @MalloryWatson ,

You can get the organization name using Index/Match. Your formula would be =INDEX({Organization Name from sheet 2}, MATCH([Market Name]@row, {Market Name from sheet 2}, 0).

You should click on the "Reference Another Sheet" link to select the sheet 2 columns for index and match. The curly brackets refer to cross sheet references. You can name it in any way, the formula above is just an example.

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.