Subject: Help with INDEX/MATCH Formula – Pulling Data from Sheet A to Sheet B

Hello,

I’m having trouble with an INDEX/MATCH formula that's intended to pull data from Sheet A (Zoho) into Sheet B (Hub) based on matching email addresses.

Here's the formula I’m currently using in Sheet B:

excelCopyEdit=INDEX({Zoho Report Range 2}, MATCH([PERSONAL EMAIL]@row , {Zoho Report Range 3}, 0))

However, the result is either #NO MATCH or the cell remains blank.

My goal is to match the personal email in Sheet B to the email column in Sheet A (Zoho Report Range 3) and then return the corresponding value from Zoho Report Range 2.

Can you help identify what I might be missing or doing incorrectly?

Find more posts tagged with

Accepted answers

All comments

Janae G.

Hello!

Your syntax looks correct, so I'm guessing there is something wrong with either the cross sheet references or the data it is trying to match.

Email addresses must match exactly. Make sure you have consistent data types for both email columns as well- just to eliminate possible errors (ex. contact list field vs text field). If the data types seem to be the issue, try changing them to match in the column properties, or try creating a helper column like this: =[Column Name]@row + "" to force a text data type on one or both as needed.

Make sure cross sheet references are referencing the column you want (and the whole column).

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.