My first VLookup

Hello, and thank you in advance for your help. I am having trouble displaying data using a VLOOKUP function (I have never used one).

My formula reads as follows:

=VLOOKUP(Predecessor@row, {PPPredTask}, {%Complete}, true)

Its goal is the following:

Based on the value in the Predecessor Column in my sheet, I would like to search the task name column in a different sheet (as defined as {PPPredTask}), and display a value from the same sheet as PPPredTask. as defined by {%Complete).

All column types are identical, but I receive an Invalid Data Type error. One variable that I am unsure if is key or not is that both the Predecessor@row and {PPPredTask} columns are the primary columns in their respective sheets.

Any help is really appreciated!

Adam

Find more posts tagged with

Formulas

Accepted answers

Jenna Bailey

Sorry, I should've also see that there is an error overall in your formula.

Where you have the {%Complete} should actually be the column reference. So if that column is column #5, the formula shhould look like

=VLOOKUP(Predecessor@row, {PPPredTask}, 5, false)

the {PPPredTask} should also be the whole range that you are looking up so if what you want to match is in column 1 and what you want returned is in column 5 then you should highlight column 1 to 5 and it would come back something like {PPPredTask Range 1}

[ vlookup(what you are looking up, lookup range with column that you want returned, COLUMN #, FALSE(orTRUE)]

Adam Rosenzweig

Jenna,

You solved my problem! You are my hero!

Thank you and have a great weekend,

Adam

All comments

Jenna Bailey

Change the true to false

Adam Rosenzweig

I actually tried that, to no avail. But thank you Jenna!

Jenna Bailey

Sorry, I should've also see that there is an error overall in your formula.

Where you have the {%Complete} should actually be the column reference. So if that column is column #5, the formula shhould look like

=VLOOKUP(Predecessor@row, {PPPredTask}, 5, false)

[ vlookup(what you are looking up, lookup range with column that you want returned, COLUMN #, FALSE(orTRUE)]

Adam Rosenzweig

Jenna,

You solved my problem! You are my hero!

Thank you and have a great weekend,

Adam

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.