KEMBAR78
Complete Excel Keyboard Shortcuts | PDF | Microsoft Excel | Computer Data
Scribd
Upload
67 views7 pages

Complete Excel Keyboard Shortcuts

The document provides instructions on using the INDEX and MATCH functions in Excel to lookup values based on multiple criteria. It demonstrates looking up a price by item and size using INDEX and MATCH with temporary columns, and with an array-entered formula. Related tutorials and products on functions, data entry, and pivot tables are also listed.

Uploaded by

singadishivu28
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
67 views7 pages

Complete Excel Keyboard Shortcuts

The document provides instructions on using the INDEX and MATCH functions in Excel to lookup values based on multiple criteria. It demonstrates looking up a price by item and size using INDEX and MATCH with temporary columns, and with an array-entered formula. Related tutorials and products on functions, data entry, and pivot tables are also listed.

Uploaded by

singadishivu28
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Online Instruction Page

Lookup Multiple Criteria Index Match

Related tutorials
INDEX and MATCH Functions
Find Text With INDEX and MATCH

Related Excel Product


30 Excel Functions in 30 Days eBook Kit

Get weekly Excel tips, tutorials, videos, and news


Contextures Excel Newsletter
Code Item Size Price INDEX and MATCH functions
SW001 Sweater Small 10 One criterion
JK001 Jacket Small 30
PN001 Pants Small 25
SW002 Sweater Med 12
JK002 Jacket Med 35
PN002 Pants Med 30
SW003 Sweater Large 14
JK003 Jacket Large 40
PN003 Pants Large 35

Code Price
JK003 40
Code Item Size Price INDEX and MATCH functions
1 SW001 Sweater Small 10 0 0 0 Two criteria - temporary columns
2 JK001 Jacket Small 30 1 0 0
3 PN001 Pants Small 25 0 0 0
4 SW002 Sweater Med 12 0 0 0
5 JK002 Jacket Med 35 1 0 0
6 PN002 Pants Med 30 0 0 0
7 SW003 Sweater Large 14 0 1 0
8 JK003 Jacket Large 40 1 1 1
9 PN003 Pants Large 35 0 1 0

Item Size Price


Jacket Large
Code Item Size Price INDEX and MATCH functions
1 SW001 Sweater Small 10 Two criteria - array-entered formula
2 JK001 Jacket Small 30
3 PN001 Pants Small 25
4 SW002 Sweater Med 12
5 JK002 Jacket Med 35
6 PN002 Pants Med 30
7 SW003 Sweater Large 14
8 JK003 Jacket Large 40
9 PN003 Pants Large 35

Item Size Price


Jacket Large 40
tered formula
Contextures Products
Pivot Power Premium Add-in
UserForms for Data Entry ebook Kit
Contextures Excel Tools Add-in
Data Entry Search Popup
Data Entry Popup
30 Excel Functions in 30 Days eBook Kit

Contextures Sites & News


Contextures Excel Newsletter
Contextures Excel Tips Website
Contextures Excel Blog
Excel Pivot Tables Blog

Other Excel Products


Contextures Recommends

www.contextures.com 03/12/2019
Time-saving tools for pivot table power users
Step by step instructions and videos
Make instant backups, sort sheets, and many more tools
Makes data entry easier when choosing from long list
Select single or multiple items from a listbox, to enter in a single cell
Sample workbook and easy to follow user guide for key Excel functions

Weekly Excel tips, tutorials, videos, and news


Hundreds of tutorials, tips and sample files
Read the Excel tutorials and share your comments
Pivot table tutorials and tips, with comments and questions

Other Excel tools and training, recommended by Debra

www.contextures.com 03/12/2019

You might also like