How to Pull Price & Quantity from Another Table | Index-Match

In this video, I show how to use INDEX and MATCH in Excel to retrieve both price and quantity from another table.

If you’ve ever worked with datasets and needed to pull multiple values based on one selection, this method will make your work much easier.

What you’ll learn:
How to structure your data for lookup
How INDEX works in Excel
How MATCH helps locate values

How to combine them to return price and quantity
Practical Excel use case for real-life data

This is a simple and beginner-friendly Excel tutorial, especially useful for anyone learning data analysis.

📌 I’m currently documenting my journey into data analysis — learning, simplifying, and sharing along the way.
#Excel #DataAnalysis #IndexMatch #ExcelTutorial #BeginnerExcel
index match multiple values
excel return multiple columns
index match price quantity
excel lookup from another table
excel data retrieval tutorial
index function excel example
match function excel tutorial
excel for data analysis beginners

Видео How to Pull Price & Quantity from Another Table | Index-Match канала Rita Onuoha