lookup data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/lookup-data/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 06:00:27 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png lookup data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/lookup-data/ 32 32 Lookup Values Across Multiple Worksheets in Excel https://www.xelplus.com/lookup-values-across-multiple-worksheets-excel/ Fri, 17 Nov 2017 07:40:00 +0000 https://www.xelplus.com/?p=11271 In this tutorial, we will address how to lookup values in multiple tabs using a single formula. You will see one method using VLOOKUP and direct worksheet and cell references, and another using INDEX & MATCH and Excel Table names and references. Both approaches rely on the INDIRECT function to return the correct sheet address in a dynamic way.

The post Lookup Values Across Multiple Worksheets in Excel appeared first on Xelplus - Leila Gharani.

]]> INDEX & MATCH for Flexible Lookups https://www.xelplus.com/excel-index-and-match/ Fri, 03 Mar 2017 12:45:00 +0000 https://www.xelplus.com/?p=12618 Learn how the INDEX and MATCH functions work individually and how putting them together allows you to conduct flexible lookups.

The post INDEX & MATCH for Flexible Lookups appeared first on Xelplus - Leila Gharani.

]]>