Results 1 to 4 of 4

Thread: Need to lookup with multiple criteria and not duplicate results
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2018
    Posts
    59
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Need to lookup with multiple criteria and not duplicate results

    Example File link :https://a.uguu.se/VShSGr3aIRRg_Example.xlsx
    I need to use vlookup with 2 criteria and 3 conditions.
    Criteria:
    Cell A2 : *AC*
    Cell B2 : Location Code for ex: 3324
    Lookup A2 in clolumn B of sheet2
    Lookup B2 in column F of sheet3

    I will use this to get 4 values : 1) Asset Code, 2) Current Cost, 3) DEP, 4) NBV
    Conditions :
    1) Provide the lowest available NBV first
    2) If Asset Code already present then provide next available asset code
    3) If description not available in provided location(B2) then pick from any location.

  2. #2
    Board Regular
    Join Date
    May 2015
    Location
    Houston, Texas
    Posts
    801
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Need to lookup with multiple criteria and not duplicate results

    Your link doesn't work...
    John 3:3 = John 3:5 = Acts 2:38

  3. #3
    Board Regular
    Join Date
    Mar 2018
    Posts
    59
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need to lookup with multiple criteria and not duplicate results

    Quote Originally Posted by Chrisdontm View Post
    Your link doesn't work...
    https://a.uguu.se/N4Z2IlGET4QX_Example.xlsx

  4. #4
    Board Regular
    Join Date
    May 2015
    Location
    Houston, Texas
    Posts
    801
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Need to lookup with multiple criteria and not duplicate results

    I believe this is most of what you are asking for...The areas shaded in gray.

    Take a look at it and let me know what else you are wanting...

    The "array" formulas I made are working off of the information in the "LOCATION" column.


    https://www.dropbox.com/s/xtbrirzhqe...mple.xlsx?dl=0

    [ FYI; If you go into the formulas, then you must use Ctrl + Shift + Enter to activate them...]
    John 3:3 = John 3:5 = Acts 2:38

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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