Index Look Up - Help a Newbie?

Hi trying to write a very basic INDEX/MATCH formula to look up the ballpark name and ballpark address from ST Addresses and insert into Arizona Schedule. My formula is saying "no match". What am I doing wrong?!

This is my formula below

=INDEX({ballpark name}, MATCH(Team@row, {Ballpark}, 0))

– writing the formula here to have the team name and address pop up in yellow cells.

Find more posts tagged with

Accepted answers

Brooke Y

Hi BrookeDawn,

I'm assuming you are using the 'reference another sheet' link in your formula? I don't see the reference names in the formula you copied in. This is what one of my formulas looks like where I am pulling the clinic name in based on the address.

=INDEX({column in another sheet you want to pull in}, MATCH(cell in row you want to match,{column in another sheet you want to match against}, 0), 0)

Hope this helps.

Brooke

All comments

Brooke Y

Hi BrookeDawn,

=INDEX({column in another sheet you want to pull in}, MATCH(cell in row you want to match,{column in another sheet you want to match against}, 0), 0)

Hope this helps.

Brooke

BrookeDawn

that worked - i really appreciate you taking the time to answer this!

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, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.