VLookup Pulling wrong information

James Sawyer

I have a Card Name in the Column in the original sheet.

I'm trying to bring the approval data and time back to the cell from "Track Approval" sheet.

I'm using the following formula.

=VLOOKUP([Card Name]@row, {Track Approval Range 1}, 1, true)

What am I doing wrong?

Find more posts tagged with

Formulas

Accepted answers

All comments

heyjay

Will you consider using Index/Match?

=INDEX({results_column},
MATCH([Card Name]@ROW,{card_name_column},0))

James Sawyer

Showing #Unparseable. Using formula =INDEX({Track Approval Range 1},

MATCH([Card Name]@ROW,{card_name_column},0))

KPH

Can you try ROW in lowercase?

James Sawyer

Showing #Invalid Ref

Using: =INDEX({Track Approval Range 1}, MATCH([Card Name]@row,{card_name_column},0))

KPH

Great! That is progress. The formula syntax is good now. The issue is with the range you are referencing.

Is the formula in the sheet you call Original sheet?
Is the reference you called {Track Approval Range 1} just referencing the Approval data and time column in your Track approval sheet?
Is the reference you called {card_name_column} just referencing the Card name column in your Track approval sheet?

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.