How to use INDEX MATCH Formulas (And Why They’re Superior to VLOOKUP) - Smartsheet
HTML-код
- Опубликовано: 28 сен 2024
- In this video, we look at how to use INDEX MATCH formulas to help you be more versatile than when using VLOOKUP formulas in Smartsheet.
If you’re often frustrated by data inconsistencies or returning NOMATCH when you move columns around in Smartsheet or Excel, we show you exactly how to remedy the issue by using dynamic Index Match formulas. In this tutorial, we also cover the advanced INDEX MATCH MATCH formula to help you link to multiple criteria within your sheets.
For more Smartsheet training options, including free and paid training, visit our website: www.cheetahtra...
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)…
thank you! It's really useful!
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
This was incredibly helpful! Thank you!
You're most welcome Abby. If you liked this, you'll definitely like our Index Collect video....