Results 1 to 4 of 4

Thread: Vlookup + match help

  1. #1
    Seeker Kelly's Avatar
    Join Date
    Dec 2011
    Location
    Sunnyvale, CA
    Posts
    5
    Articles
    0

    Question Vlookup + match help



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

    I need a formula to look up a specific month, then find the P/N, then tell me the total qty for that P/N for that month.
    Is this possible?
    MONTH P/N Qty
    Nov SA0016 3
    Nov SA0083 6
    Nov SA0083 5
    Dec SA0116 9
    Dec SA0083 7

  2. #2
    Hi Kelly...

    I attached to this thread a sample workbook, which, perhaps, may help and includes a possible solution using a helper column. There are two sheets in the workbook, one assuming the Month names are entered as strings and one assuming the values are dates = numbers.

    Best Regards :-)
    Attached Files Attached Files

  3. #3
    Seeker Kelly's Avatar
    Join Date
    Dec 2011
    Location
    Sunnyvale, CA
    Posts
    5
    Articles
    0
    Thank you so much!!! That is exactly what I was looking for!!!!

  4. #4
    Hi Kelly, fine that it works, thanks

Posting Permissions

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