Results 1 to 5 of 5

Thread: Vlookup table array based on criteria

  1. #1

    Vlookup table array based on criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear All,
    can you pls help with the following problem? I have the attached simplified table, where I would like to return Comment next to an Invoice based on the date in column 3. I need the specific comment on day (they are changing over time) but invoice numbers are repeating in the list.


    How can I solve this easily? I was thinking of adding another column with the invoice+date combination using concatenate function and building the vlookup formula on the invoice+date combination, but would prefer solving it in one step without adding more columns.

    Thanks for the help in advance,
    zarija
    Attached Files Attached Files

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    Hi zarija,

    Your sample table includes entries for the same invoice and on the same day. Is that likely to occur in your actual data?

  3. #3
    hi CheshireCat,

    no, sorry, that should not happen. Invoices can appear more times, but only with different dates.
    thanks,

    zarija

  4. #4
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    Try this arrangement.

    Change the invoice and/or date values in F2 and F3 to see the corresponding Comment in F4.

    Note - The formula is confirmed as an array formula with Ctrl-Shift-Enter.
    Attached Files Attached Files

  5. #5
    thank you CheshireCat!

Posting Permissions

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