Index & Match
INDEX & MATCH are two useful excel functions that provide a solution to VLOOKUPs limitations.
Unlike VLOOKUP, INDEX & MATCH can lookup the column and the row matching the specified criteria and return the value at their intersection.
Don’t be overwhelmed – watch the intro video below and sign up for our free course on Index & Match here. In the course I’ll explain everything in simple to follow steps.