VLOOKUP via another Smartsheet not working..
Hi All,
Noob here.. Im trying to perform a VLOOKUP via a second smartsheet, but I keep geting the error "#INCORRECT ARGUEMENT SET", I cant see what I'm doing wrong, can you help please?
This is smartsheet 1 and my formula that I want to populate from smartsheet 2:
This is smartsheet 2, where I want to pull data from:
This is the error I get in smartsheet 1:
Thanks for any tips!
Answers
-
Hi @neiko,
What is your cross sheet reference looking at? I think it might be only selecting a single column, which is what causes the error as your VLOOKUP is trying to get the value in a non-existent (to it) second column in a range.
-
Give an INDEX/MATCH a try. It is much more resilient than the VLOOKUP function.
=IFERROR(INDEX({Description Column}, MATCH(Ref@row, {Ref Column}, 0)), "")
-
Hi Nick, I think its looking at the second column in the "Intake" smartsheet, so the "Description" column. I say I think as when im building the formula, I click on "Reference Another Sheet", then from the "Intake" sheet I select the second column (which is Range 2 apparently). Not sure if Im correct doing this, see pics below:
Above is me selecting "Reference Another Sheet" and below me electing the second column namesd "Description":
This ends up with the following formula:
=VLOOKUP(REF@row, {Intake Range 1}, 2, false)
-
Hi Paul, thanks for this! I'll try it also. For my learning I'll try to get both working with you guys helping me. Appreciate the tip!
-
When you select the range it should be highlighting multiple columns, not just one - this is what the issue is.
Your cross sheet reference should look something like this:
You can shift+click on the headers to get a range, or ctrl+click on the headers to get a selection of columns (or combine the two to get a range and then take one/some out!).
-
Damn! Worked! Thank you! 🙏
=IFERROR(INDEX({Intake Range 1}, MATCH(REF@row, {Intake Range 2}, 0)), "")
Interestd to find out why the VLOOKUP didnt work. Thanks a lot for this Paul 😁
-
Happy to help. 👍️
The VLOOKUP wasn't working because you were not selecting the appropriate range for that particular function. The range in a VLOOKUP needs to be the column to match on (as the leftmost column in the reference table) through the column to pull from (and every column in between).
-
That worked also! You guys are legends!! Thank you!!
-
Thats it! Ive only started with formulas yesterday, you have made my evening gents, thanks again 😁
-
No problem, glad everything is sorted for you now! 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
