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
Best Answers
-
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)]
-
Jenna,
You solved my problem! You are my hero!
Thank you and have a great weekend,
Adam
Answers
-
Change the true to false
-
I actually tried that, to no avail. But thank you Jenna!
-
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)]
-
Jenna,
You solved my problem! You are my hero!
Thank you and have a great weekend,
Adam
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!