+ Reply to Thread
Results 1 to 11 of 11

how to vlookup based on one row and 2 columns?

  1. #1
    Registered User
    Join Date
    03-13-2023
    Location
    Paris, France
    MS-Off Ver
    2302
    Posts
    11

    how to vlookup based on one row and 2 columns?

    Hello there
    I found a index + match Google sheet formula to find a cell based on row AND column. But I was wondering if it's possible to do it with 2 conditions from the header.
    I have 2 scenario represented in sheet 1 and sheet 2:
    FIRST: find the cost share of a certain product for a specific market
    SECOND: find the cost share of a certain product from a specific range and for a specific market
    I would appreciate any help you could provide, please

    Many thanks
    P.

    find a cell from multiple values.xlsx

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: how to vlookup based on one row and 2 columns?

    Perhaps add some manually calculated expected results to your sheet?

  3. #3
    Registered User
    Join Date
    03-13-2023
    Location
    Paris, France
    MS-Off Ver
    2302
    Posts
    11

    Re: how to vlookup based on one row and 2 columns?

    Sure thanks: I would like to automate the highlited cells because I have lots of tables like this for all different countries with lots of productsfind a cell from multiple values (1).xlsx

  4. #4
    Registered User
    Join Date
    03-13-2023
    Location
    Paris, France
    MS-Off Ver
    2302
    Posts
    11

    Re: how to vlookup based on one row and 2 columns?

    By the way, it's not a calculation. Its a vlookup of a cell but based on multiple criteria. Hope it's clearer

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: how to vlookup based on one row and 2 columns?

    I'm sorry I don't understand what you are trying to do. But perhaps someone else will?

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: how to vlookup based on one row and 2 columns?

    Is this a Googlesheets Q or an Excel Q? You've posted it in the GS subforum, but it looks lo=ike you have O365, looking at your profile...
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: how to vlookup based on one row and 2 columns?

    Also, there are no expected results in the latest file. Did you upload the wrong file?

  8. #8
    Registered User
    Join Date
    03-13-2023
    Location
    Paris, France
    MS-Off Ver
    2302
    Posts
    11

    Re: how to vlookup based on one row and 2 columns?

    the expectation are not a calculation I just want to "call" numbers from sheet 1 into the yellow cells. But because I have many tables like this in my original sheet with many countries, it's a pain to do it manually and I would like to find a formula that is "finding" a cell based on 2 headers and 2 columns.
    Hope it's clearer

  9. #9
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: how to vlookup based on one row and 2 columns?

    I'll play the guessing game.
    The formula in cell C5 is: =SUMPRODUCT((Sheet1!B$3:I$9)*(Sheet1!B$1:I$1=B$3)*(Sheet1!B$2:I$2="cost share")*(Sheet1!A$3:A$9=B5))
    Note that cell B3 contains a drop down list of the list of countries in column H.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  10. #10
    Registered User
    Join Date
    03-13-2023
    Location
    Paris, France
    MS-Off Ver
    2302
    Posts
    11

    Re: how to vlookup based on one row and 2 columns?

    Brilliant!!!! thank you so very much. It saves me lots of time :D

  11. #11
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: how to vlookup based on one row and 2 columns?

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] vLookUp and Transpose between different sheets/files based on two values from two columns
    By naumanxkhan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2020, 12:17 PM
  2. [SOLVED] VLOOKUP with named columns, need to match the name based on first row
    By dcwan in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-17-2019, 08:34 PM
  3. VLOOKUP Return Value based on 2 Columns, One may be blank
    By kevinmcmanus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2016, 11:38 AM
  4. Matching multiple columns based on vlookup
    By golffor1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-11-2013, 10:36 PM
  5. VLOOKUP MAX score based on multiple columns
    By Eric3483 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-06-2012, 09:20 AM
  6. Vlookup based on values from two columns
    By lamp123 in forum Excel General
    Replies: 4
    Last Post: 06-04-2012, 01:41 PM
  7. Replies: 2
    Last Post: 08-17-2010, 10:08 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1