Great to know that it helped you Nita and thanks for the comment. You should look at our Index Collect video next, as this lets you return results based on multiple criteria (instead of the single criteria with an Index match formula)...
Great! Been adding all my new columns at the end to get past the vlookup constraints and turned out my counting was not too good either :-) This solves it all!
Can you please explain why this formula is not working : =IFERROR(INDEX({3.COLUMN3}, MATCH([Primary Column]@row, {1.COLUMN1}, MATCH(Name@row, {2.COLUMN2}, 0))), "Not Found") The 'Match' works one at a time, but doesnt work when there are 2 'match' functions in the formula
Personally, we would recommend using an Index(Collect formula instead of an Index(Match(Match. This will ensure that you are not restricted to upto two matches. Watch our video below on how to complete. ruclips.net/video/WnecLKVCg-o/видео.htmlsi=Jj1MCxs62r5Ilsnj
![How to Use Smartsheet Document Builder [OVERVIEW]](/img/1.gif)
This is so good to know! I was getting frustrated with my VLOOKUP formulas not working when I moved columns around! Thank you!
Great to know that it helped you Nita and thanks for the comment. You should look at our Index Collect video next, as this lets you return results based on multiple criteria (instead of the single criteria with an Index match formula)...
Great! Been adding all my new columns at the end to get past the vlookup constraints and turned out my counting was not too good either :-) This solves it all!
If you’re enjoying Index Match formulas, you’ll absolutely love Index Collect formulas (we’ve got a video on that also)…
This was incredibly helpful! Thank you!
You're most welcome Abby. If you liked this, you'll definitely like our Index Collect video....
marvellous! Thank you mate, you safe me. Lot of headaches away
Great to hear. If you like Index Match formulas, you will absolutely love our video on Index Collect formulas.....
Can you please explain why this formula is not working : =IFERROR(INDEX({3.COLUMN3}, MATCH([Primary Column]@row, {1.COLUMN1}, MATCH(Name@row, {2.COLUMN2}, 0))), "Not Found") The 'Match' works one at a time, but doesnt work when there are 2 'match' functions in the formula
Personally, we would recommend using an Index(Collect formula instead of an Index(Match(Match. This will ensure that you are not restricted to upto two matches. Watch our video below on how to complete.
ruclips.net/video/WnecLKVCg-o/видео.htmlsi=Jj1MCxs62r5Ilsnj
thank you! It's really useful!