Comments on: Excel INDEX MATCH MATCH and other formulas for two-way lookup

When searching for something in your Excel spreadsheets, most of the time you'd look up vertically in columns or horizontally in rows. But sometimes you need to look across both rows and columns. This is called a two-dimensional lookup, and this tutorial shows how to do it in 4 different ways. Continue reading →

Table of contents

Comments page 2. Total comments: 62

  1. Hi Svetlana,
    How can I find row title based on the matrix value. In you Example I want to find row title for D3 (22,000) or E4 (2500). I need a reverse formula. It means I have the year and population but need to know where they belong to, Tiger, Polar bear,..
    How can I solve it.
    Ali

  2. Thank you! I’ve looking for the index match match. Beautifully and easily put together.

  3. Can you please advise how we can drag the results down to apply the formulae to multiple rows in a sheet.

    I tried double clicking the square and also the copy pste special formulae in mass but does not seem to update the value until we double click in the formula itself.

    Thank you,

    Nikhil

  4. hi need help with this
    with the assigned value like a=1 , s=2, d=3, f=4
    then fads=4132
    tnx,

  5. Please also explain Xlookup and Xmatch which seem to replace not only vlookup/hlookup but also Index and Match

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)