VLOOKUP

Carlos Yanes

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!

Paul Newcome

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.

Paul Newcome

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.

Carlos Yanes

Carlos Yanes

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.

Paul Newcome

Is that error present anywhere in the source sheet?

Carlos Yanes

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

Paul Newcome

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

Carlos Yanes

Sure, see below -

Paul Newcome

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

Carlos Yanes

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

Paul Newcome

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.

Carlos Yanes

@Paul Newcome

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

Paul Newcome

Happy to help. 👍️

Paul Chumak

@Carlos Yanes What was the solution??

Paul Chumak

@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 Newcome

@Paul Chumak Are you getting an error or an incorrect output?