#1
|
|||
|
|||
Match & Index function
Is there a good tutorial and/or practice site to help with how to learn and utlize the Match and Index function? I currently use VLOOKUP for large sets of data, and would like to learn how to use the Match & Index function to see if it would be a better choice.
|
#2
|
||||
|
||||
Hi and welcome
might a suggest you browse the web ? There are tons of tutorials out there. Just look for INDEX/MATCH combination Cheers
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Quote:
Leila Gharani: https://youtu.be/F264FpBDX28 and https://youtu.be/ontXHp9cwOQ Kevin Stratvert: https://youtu.be/6JhbY8Mku1A Mynda at MyOnlineTrainingHub: https://youtu.be/pP7AMLJa0Vc (this is more on the INDEX function overall) If you have a later version of Excel, check out XLOOKUP also. I use it in Office 365. |
#4
|
|||
|
|||
Thank you for the suggestions.
|
#5
|
||||
|
||||
lease mark thread as solved. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Index Match Function with a Date | Priyantha Gamini | Excel | 9 | 02-03-2023 10:39 PM |
Index and Match Function | mismag | Excel | 5 | 05-29-2019 11:26 AM |
Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
Index Match function | jackzha | Excel | 5 | 12-03-2014 12:43 PM |
Moving a Index/Match function | FraserKitchell | Excel | 2 | 01-19-2010 09:38 AM |