VLOOKUP formula error message

Hi ,

I need help with the VLOOKUP formula .

I have a VLOOKUP formula that works from one sheet to another. I am confused as I get: '# Incorrect Argument Set' as an error.

=VLOOKUP({Code livrable}; {Planning actualisé / plage}; 10;false)

The below is the formula :

{Code livrable} is the first column range

{Planning actualisé / plage} is the table range in which we have to pick up data from the 10 th column

Can we help ?

Thanks in advance .

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @ALAIN-STEPHANE

Hope you are fine, in your formula i don't see the value you are searching for, the following is vlookup syntex:

VLOOKUP( search_value, lookup_table,column_num, [ match_type ])

ALAIN-STEPHANE

Hi @Bassam Khalil , the search value belongs to a column named : « Code livrable » .

{ Code livrable } is the fisrt column range

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.