Two Way Lookup Formula Using INDEX and MATCH

Create a two way lookup formula using the INDEX and MATCH functions. This versatile and dynamic lookup formula will look for data in any row or column. The most common lookup formula is VLOOKUP. This is useful but restrictive. The INDEX and MATCH functions together are very flexible. You can return data from a column to the left of the lookup value column, and also create a dynamic column to return from. Visit Computergaga For Lots More Tips https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1