Index and Match
INDEX and MATCH can be combined to perform flexible lookups. MATCH identifies the position of a value within a range, while INDEX returns the value from a specified position in another range. The combination is particularly useful when working with older Excel versions or spreadsheets that already use INDEX and MATCH.
How would you like to use this resource?
Purchase this resource or use an active membership to open it.Protected previewPurchase this resource or use an active membership to open the complete PDF.
About this resource
Designed for A4 Portrait printing. Keep your printer set to actual size for the intended result.
Recommended material: Paper£2
Secure Stripe checkout is being prepared. You may add this resource to your basket, but no payment will be attempted until checkout is securely enabled.
Or view Membership for accessMicrosoft Excel
Protected previewPurchase this resource or use an active membership to open the complete PDF.