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 .
Answers
-
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 ])
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Bassam Khalil , the search value belongs to a column named : « Code livrable » .
{ Code livrable } is the fisrt column range