VLOOKUP
Hey all,
I'm having trouble with a vlookup formula and not sure how to correct. I'm using the below 
=VLOOKUP([Task Name]@row, {Einstein Credits and Adjustments}, 8, false)
On the sheet where the formula is located, I want it to look up the column 'Task Name' then go to the second sheet 'Einstein Credits and Adjustments' and look up the value Task Name and bring back the results listed in column 8. When I enter this, I end up getting the Incorrect Argument Set error.
Thank you!
Best Answer

Double check that your range is actually covering all of the appropriate columns and that there are in fact 8 columns within the range. Column # 1 in this instance would be the far left column used for matching, so the column you are pulling from should be 7 more columns to the right.
Answers

Make sure you range in your cross sheet reference covers the entire table starting with the column that will be used for matching on the far left and the column to pull from on the far right.


Thanks @Paul Newcome
I think that's where I'm running into the issue, even when selecting the entire table, it still does not change the formula.


Nope, only in the destination where the formula is located.

Are you able to provide a screenshot of the formula in the sheet similar to the screenshot below?

Sure, see below 

There's the problem. You didn't finish out the formula. In the screenshot the last two arguments of the VLOOKUP are missing.

Not sure why the whole thing didn't copy right, but it's actually listed as 

Double check that your range is actually covering all of the appropriate columns and that there are in fact 8 columns within the range. Column # 1 in this instance would be the far left column used for matching, so the column you are pulling from should be 7 more columns to the right.

Got it working  thanks as always for your help and support.


@Carlos Yanes What was the solution??

@Paul Newcome Im having the same issue
I added the quotation marks because the VLOOKUP documentation says: To look up text strings, you must enclose the lookup value in quotation marks (for example, “Task E”).
I want to search the "Email Address" column (column 1) for the values in the "Existing Email Address" column (last column) and return the value in the adjacent "Existing User ID" column into the "User ID" column.
As far as I can tell I've met all the requirements, Email address is the first column, that column is sorted in ascending order, text string has quotations, the lookup table includes all relevant columns and I've referenced column 5 which is the column that contains the value I want to return....

@Paul Chumak Are you getting an error or an incorrect output?
Help Article Resources
Categories
Check out the Formula Handbook template!