Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

Tag Archives for " vlookup "

How To Perform Two Way Lookup In Excel

    how to perform two way lookup in excel featured image

    Performing a two way lookup is all about getting a value from a two-dimensional table. That means you can get a value from any cell of a table. And for this, you need to combine match function with vlookup. As you know, normal vlookup is only able to return a value by looking into a single […]

    Check it out now

    How To Use VLOOKUP Approximate Match Technique To Create Magic


      In this post, you will learn to create a VLOOKUP Approximate Match to get values from a range. The Idea is very simple to lookup for a value & get values which are approximately matched with lookup value. In this post, I will show how to perform this VLOOKUP Approximate Match so you will able to […]

      Check it out now

      How To Use Vlookup and Match as a Combination

        Using VLOOKUP With MATCH Will Make You A Dynamic Data Pro

        In this post, I’ll reveal the secret about how I use VLOOKUP And MATCH to create data for my Dynamic Charts. I’ll also tell you about reasons to use VLOOKUP And MATCH to increase the power of VLOOKUP. But before doing this let me explain you everything about the combination of these two awesome functions.

        Check it out now