vlookup error message
What am i doing wrong with my formula: =VLOOKUP(MSN@row, {Conversion History 12.15}, 6, false)?
I update my reference sheet every month and every month i always get error message #incorrect argument set when i try to update. I tried both updating the reference sheet and writing the formula from scratch but always get this error message.
Answers
-
It looks like your lookup_table part is not correct.
=VLOOKUP(MSN@row, {Conversion History 12.15}, 6, false). The 12.15 doesn't look like a ran.
Here is on I have on several of my sheets that do the same thing you are refereeing to.
=VLOOKUP([Product Name]23, {MTC Master Weight sheet Range 1}, 9, false)
-
@Mike Arbaugh I change my formula to the same as yours but still getting the same error message: =VLOOKUP(MSN@row, {Conversion History 12.15 Range 1}, 6, false)
-
When you select your range, do you select the first row, hold shift down to highlight the rows? Then count over from the first row to the row you want to pull data from. Is that row #6?
-
@Mike Arbaugh yes - the first row is my search value and #6 is my column number that I want the data to return
-
Can you send a screen shot of the top columns?
-
I just made a test sheet and it worked. Here is what I did.
1) Went to the row I wanted to put formula in.
2) Started with =VLOOKIP(.
3) Selected the MSN@row. This is what I am looking for.
4) =VLOOPUP(MSN@row, Now I went to the source sheet.
5) Selected the row I am looking for the match in from the MSN row, held down shift and went across the find the data row I want to pull back.
6) This gives we =VLOOPUP(MSN@row, {Test 2 Range 1}, Then I counted over and it is row 6 with my data. I count from the lookup column to the data column. If you are using "false" the MSN row has to match the first lookup. If it is not the same on both sheet and formatted the same, it will give an error also.
=VLOOKUP(MSN@row, {Test 2 Range 1}, 6, false)
-
this is the formula that I use but still getting the error message! :(
-
Have you checked to make sure columns are the same in both sheets? Make sure if its a number column, it is the same on both sides.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!