Excel Lookup Series #8: MATCH Function

See how to use the MATCH function! The MATCH function looks up a value and tells you what relative position it is in the list, or what ordinal position it is in the list. Although by itself, the function is not too useful, when matched with the INDEX function, it does great things!

In this Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.

This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.

Category:

Science & Technology

Tags:

• Excel
• MATCH
• function
• relative
• position
• ordinal
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[hersheng18]

i've been watching almost of your videos. great job!

[ExcelIsFun]

@hersheng18 , I am glad that you find them useful!

[alpinepatriot]

Every tutorial, simply amazing... Thank YOU!

[ExcelIsFun]

You are welcome!

[eapeters12]

aside from your fantastic teaching, you've got a great sense of humor too. Its a pleasure to learn from you!!

[ExcelIsFun]

I am glad that it helped!

[burceavc]

I want to return a table like this

AR-12-total 89

AX-22-total 20+6=26

AX-9-total 200

BS-12-total 38

DD total 300

Thank you in advance

Vio Romania

[burceavc]

AR-12-89

AX-22-20

BS-12-38

AX-22-6

AX-9-200

DD 300

[burceavc]

hi

Please can you help me with a table, I try for 3 days and no success

I have this table

Cable Type Length

[burceavc]

hi