How to VLOOKUP Across Multiple Worksheets | Using VLOOKUP, INDIRECT, MATCH & INDEX

In this video I demonstrate how to perform a VLOOKUP across multiple worksheets in the same workbook. In my example I need to lookup product information any one of four worksheets. This method uses the following functions: VLOOKUP, INDIRECT, MATCH and INDEX.

Table of Contents:

00:00 - Introduction
00:29 - Create a list of sheet names and create a named reference for the list
01:36 - Create a reference to each worksheet's data
03:52 - Use COUNTIF to identify which sheet the product is in
04:20 - Use INDIRECT to convert a string into a range reference
05:25 - Use MATCH to find the numeric position of the sheet
06:02 - Use INDEX to return the sheet name
07:11 - Use VLOOKUP, INDIRECT, MATCH and INDEX to return the product price
------------------------

[EdwardDZN]

Extremely specific problem so I really appreciate you taking your time making this video, it helped me a lot! Thank you!

[IvanCortinas_ES]

Excellent video. It is a real business application. . Thank you Chester!!!

[abigailamponsaah]

Thank you, sir! I've been trying to do this for a few hours now and kept getting errors. You've saved me possibly hours more of searching. God bless you.

[AbdullaKhizamworld]

Possible to give me on Sumifs where Answer to come one Different Sheet and Database on Differnt Sheets using more than 03 conditions. using VBA

[ubaidillahmuhammad]

Amazing job. Please put file excel as usual

[swapnarajsinhvaghela]

Hey Chester
Liked very much your video and explanation.

This is an awesome application of some basic formulas to solve a complex process.

Keep it up 👍

Waiting for your next video.