VLOOKUP Help - Incorrect Argument Set error

ParkinsGA

I am stuck with an "Incorrect Argument Set" error when I try to use VLOOKUP. On Sheet 1, I have a column called "User Name." I am adding a helper column tacked onto the right side of a large timesheet report pasted in from a .csv file.

I'd like to use VLOOKUP to retrieve the user's name as it appears in my payroll reports. For example, "efudd" needs to return "Fudd, Elmer" to the helper column. The sheet has 200+ rows and about 10 users.

"VLOOKUP Test" is a 2-column translation table (see attached screenshot). Column 1 (the Primary column) is the username, and column 2 is the payroll name.

My formula is:

=VLOOKUP([User Name]@row, {VLOOKUP Test Range 1}, 2)

The screenshot is of the cross-sheet reference from Sheet 1.

I am not seeing a syntax error, and I can't figure out what I'm missing. Any help is appreciated!

Paul Newcome

The {Range} for a VLOOKUP needs to be multiple columns. The leftmost column houses the value to look up and match against, and the multi-column range must include the column you want to pull over.

ParkinsGA

Sufferin' succotash, that did it!

Thank you very much, @Paul Newcome

Paul Newcome

Happy to help. 👍️

Kristen Cummings

Hi Parkins,

It appears you are missing the match type.

Try this: =VLOOKUP([User Name]@row, {VLOOKUP Test Range 1}, 2, FALSE)

Paul Newcome

@Kristen Cummings The match type in a VLOOKUP is optional. The issue was the range.

Kristen Cummings

Thanks for the clarification @Paul Newcome I see that now!