How to VLookup Instructor Client from a sheet
Answers
-
=IFERROR(INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 2}, First@row, {Master DPS Directory Range 3}, Last@row), 1), "")=IFERROR(IFERROR(INDEX(COLLECT(name), 1), INDEX(COLLECT(nickname), 1)), "")
Using the above in the cell it is saying that the syntax isn't quite correct
-
When adding the formula suggested below:
=IFERROR(INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 2}, First@row, {Master DPS Directory Range 3}, Last@row), 1), "")=IFERROR(IFERROR(INDEX(COLLECT(name), 1), INDEX(COLLECT(nickname), 1)), "")
It is saying the sytax isn't quite right
-
Because the syntax is still not correct. You need to make sure you are using the same syntax (aside from the internal piece of each COLLECT function) to include = signs, parenthesis, and other functions.
I am indicating:
=IFERROR(IFERROR(INDEX(COLLECT(name), 1), INDEX(COLLECT(nickname), 1)), "")
You are doing:
=IFERROR(INDEX(COLLECT(name), 1), "")=IFERROR(IFERROR(INDEX(COLLECT(name), 1), INDEX(COLLECT(nickname), 1)), "")
Not only is the overall syntax incorrect, but you are not filling out the COLLECT portion of the INDEX/COLLECT for the nickname.
-
I tried:
=IFERROR(IFERROR(INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 2}, First@row, {Master DPS Directory Range 3}, Last@row), 1), INDEX(COLLECT({Master DPS Directory Range 4}, 1)), ""))
Am I missing something or adding information on the formula that is not needed?
-
You are missing the rest of the second COLLECT function.
-
I am not sure what should be added for the rest of the second collect function.
-
It is going to be exactly the same as the first COLLECT except instead of matching on first and last you are match on the nickname.
-
I tried:
=IFERROR(IFERROR(INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 2}, First@row, {Master DPS Directory Range 3}, Last@row), 1), INDEX(COLLECT({Master DPS Directory Range 1} {{Master DPS Directory Range 4}, Nickname@row, 1)), ""))
-
The syntax is still off in the second COLLECT. Make sure that the curly brackets and commas are all how they should be.
-
I tried the below:
=IFERROR(IFERROR(INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 2}, First@row, {Master DPS Directory Range 3}, Last@row), 1)), INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 4}, Nickname@row), 1), ""))
The second collect is exactly the same as the above I am getting an error code as well
-
Now you have adjusted the closing parenthesis. Make sure that parenthesis match what I suggested.
-
I tried the below:
=IFERROR(IFERROR(INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 2}, First@row, {Master DPS Directory Range 3}, Last@row), 1)), INDEX(COLLECT({Master DPS Directory Range 1}, {Master DPS Directory Range 4}, Nickname@row), 1)), "")
I feel as if I matched the parenthesis.
-
Your closing parenthesis are still off. There should only be one after the first 1 and two after the second 1.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
