+ Reply to Thread
Results 1 to 5 of 5

Xlookup dual criteria

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    194

    Xlookup dual criteria

    Hi. I manage a warehouse. We do daily picks for techs based on where they are location. I have one pick sheet on its own tab. I have the part allowances on another tab.

    We select the employee. That looks up his location. Then next to the part there should be a number matching the allowance for that part at that location. The older version used a VLOOKUP with a Match formula to designate the return column. I tried that and it got a #Value error because it was just counting the number of columns in the range. I've enclosed a really simplified two-tab workbook if anyone would like to teach an old dog new tricks...

    Thank you for looking and any insights.
    Attached Files Attached Files

  2. #2
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Xlookup dual criteria

    worksheet name : pick sheet

    OFFICE365

    Cell B4 formula , Drag down


    XLOOKUP FUNCTION

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    FILTER FUNCTION

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Other office version Cell B4 formula , Drag down

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by wk9128; 01-13-2022 at 07:31 PM.

  3. #3
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    194

    Re: Xlookup dual criteria

    Quote Originally Posted by wk9128 View Post
    worksheet name : pick sheet

    OFFICE365
    Cell B4 formula , Drag down
    XLOOKUP FUNCTION
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    FILTER FUNCTION
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Other office version Cell B4 formula , Drag down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    That is perfectly adaptable to our workbook. Thank you very much. I really appreciate your time.

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Xlookup dual criteria

    @Mr_Phil You're Welcome. Glad to help . Thank You for the feedback

  5. #5
    Registered User
    Join Date
    10-28-2008
    Location
    Turkey
    Posts
    88

    Re: Xlookup dual criteria

    Also, you can use:

    Please Login or Register  to view this content.

+ 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. Xlookup with multiple criteria
    By Mackay2m in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-12-2022, 04:09 PM
  2. Multi-criteria lookup help (XLookup?)
    By miketomei in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-18-2021, 04:12 AM
  3. [SOLVED] Xlookup for two criteria vertical and horizontal
    By gjjh25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-13-2021, 08:47 AM
  4. XLOOKUP searching in two places for the same criteria?
    By Msilvester in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-22-2021, 12:51 PM
  5. Help on XLOOKUP formula with multiple criteria
    By lyzas in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-22-2021, 05:06 AM
  6. Multiple criteria for XLOOKUP formula
    By mikehk in forum Excel General
    Replies: 1
    Last Post: 06-28-2021, 05:50 PM
  7. Dual Criteria
    By sally100 in forum Excel General
    Replies: 4
    Last Post: 03-08-2005, 07:08 AM

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