+ Reply to Thread
Results 1 to 6 of 6

Xlookup for two criteria vertical and horizontal

  1. #1
    Forum Contributor
    Join Date
    09-06-2011
    Location
    manchester england
    MS-Off Ver
    Office 365
    Posts
    282

    Xlookup for two criteria vertical and horizontal

    I am trying to get xlookup to find two criteria one in a column and one in a row and then return the value that corresponds.

    I have enclosed an example of what i thought would work but I am getting a value error.

    If anyone can help please it would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Xlookup for two criteria vertical and horizontal

    Try

    =INDEX('Client List'!E4:F18,MATCH(C5:C6,'Client List'!A4:A18,),MATCH(E5:E6,'Client List'!E3:F3,))
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Xlookup for two criteria vertical and horizontal

    Personally I'd stick with an index/match/match as Bo_Ry has used, but to do it with xlookup it should be like
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,775

    Re: Xlookup for two criteria vertical and horizontal

    GWKS Matrix

    F5=IFERROR(SUMIF('Client List'!$A$4:$A$100,'GWKS Matrix'!$C5,INDEX('Client List'!$E$4:$F$100,,MATCH('GWKS Matrix'!$E5,'Client List'!$E$3:$F$3,0))),"")

    Copydown

  5. #5
    Forum Contributor
    Join Date
    09-06-2011
    Location
    manchester england
    MS-Off Ver
    Office 365
    Posts
    282

    Re: Xlookup for two criteria vertical and horizontal

    Thank you all for your help. I managed to get it work, a while after posting the question. Same as Fluff13 solution.

    Great community and the help was much appreciated.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Xlookup for two criteria vertical and horizontal

    Glad to help & thanks for the feedback.

+ 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] xlookup - checking 2 lots of data vertical and horizontal
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-16-2021, 08:44 AM
  2. Countif with Horizontal and Vertical criteria
    By iansl2000 in forum Excel General
    Replies: 6
    Last Post: 12-08-2020, 07:00 AM
  3. Need help with Countifs that has vertical/horizontal criteria
    By looking_to_improve5 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-14-2018, 07:53 PM
  4. Replies: 6
    Last Post: 06-07-2017, 10:25 AM
  5. Replies: 5
    Last Post: 10-03-2016, 03:39 AM
  6. Sum data with vertical and horizontal criteria
    By Vernell10 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2016, 10:01 AM
  7. Sum with multiple criteria Horizontal and Vertical
    By freqzz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2015, 04:39 AM

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