VLOOKUP formula error message

ALAIN-STEPHANE

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 .

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