Xlookup and Vlookup
Lookup functions search for a value in one area of a worksheet and return related information from another. They are useful when working with product codes, staff IDs, customer numbers, price lists and other data where one value identifies a record.
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.