Results 1 to 5 of 5

Thread: Note lookup with 2 conditions
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2012
    Location
    Redditch, England
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Note lookup with 2 conditions

    Hi I have a table that has
    Col A = Date
    Col B = Customer name
    Col C = Product
    Col D = Note

    I need a formula that will populate a cell with the relevant note in a separate worksheet based on the most recent note (based on date added)
    for customer x and product y

    For example if cell B8 = customer x and cell E7 = product y then the most recent note added for that is ???

    Many thanks in advance!

  2. #2
    Board Regular FDibbins's Avatar
    Join Date
    Feb 2013
    Location
    Duncansville, PA USA
    Posts
    6,723
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Note lookup with 2 conditions

    Hard to say without seeing more detail on what you are working with, but I would probably add a helper column and combine Customer and Product, then use INDEX/MATCH based on that combo and search for the MAX date

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    Regards

    Ford

  3. #3
    Board Regular
    Join Date
    Jan 2009
    Location
    Hong Kong
    Posts
    791
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Note lookup with 2 conditions

    Not exactly understand your requirement.
    Here's an article for your reference.
    Perform VLOOKUP with 2 lookup values | wmfexcel


    Quote Originally Posted by Kerrold View Post
    Hi I have a table that has
    Col A = Date
    Col B = Customer name
    Col C = Product
    Col D = Note

    I need a formula that will populate a cell with the relevant note in a separate worksheet based on the most recent note (based on date added)
    for customer x and product y

    For example if cell B8 = customer x and cell E7 = product y then the most recent note added for that is ???

    Many thanks in advance!
    A simple spreadsheet you can manage could be a better choice than a sophisticated spreadsheet you need help from time to time.
    http://wmfexcel.com/welcome/

  4. #4
    New Member
    Join Date
    Mar 2012
    Location
    Redditch, England
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Note lookup with 2 conditions

    Thank you for the link mfxcel, greatly appreciated!

    I used the Index Match formula as follows

    =INDEX(Notes!H:H,MATCH(1,(Notes!F:F=Summary!B8)*(Notes!G:G=Summary!F7),0))

    Thank you in advance!

  5. #5
    Board Regular
    Join Date
    Jan 2009
    Location
    Hong Kong
    Posts
    791
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Note lookup with 2 conditions

    You are welcome. Glad that it helps.
    btw, try not to use whole column referencing.


    Quote Originally Posted by Kerrold View Post
    Thank you for the link mfxcel, greatly appreciated!

    I used the Index Match formula as follows

    =INDEX(Notes!H:H,MATCH(1,(Notes!F:F=Summary!B8)*(Notes!G:G=Summary!F7),0))

    Thank you in advance!
    A simple spreadsheet you can manage could be a better choice than a sophisticated spreadsheet you need help from time to time.
    http://wmfexcel.com/welcome/

Some videos you may like

User Tag List

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
  •