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 ])
bassam.khalil2009@gmail.com
☑️ 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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives