Incorrect Argument Set error when using Vlookup to reference another sheet.

I am using a Vlookup to use a row id in sheet A to lookup the corresponding row id in sheet B and return the value in the status column - the syntax looks correct to me but I am getting an Incorrect Argument Set error.

This is the syntax I am using:

=VLOOKUP([Row ID]@row, {Cutover Tasks Range - Row ID}, 6, false)

Can you tell me what is wrong here?

Thanks

Find more posts tagged with

Formulas

Accepted answers

All comments

Mark.poole

Are all the Columns in the ref right next to each other. This requirement is why i prefer using Index Match

=Index({Status Ref},Match([Row ID]@row,{Row ID Ref},0))

DLanca

Hello,

Thanks for the info. I have tried the using Index Match as you suggested and am getting an #INVALID REF error on this:

=INDEX({Range - Row ID}, MATCH([Row ID]@row, {Row ID Ref}, 6))

Any ideas

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.