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
    118
    Articles
    0
    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
    118
    Articles
    0
    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
  •