+ Reply to Thread
Results 1 to 3 of 3

vlookup to return value based on previous months

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    Australia
    MS-Off Ver
    O365
    Posts
    2

    vlookup to return value based on previous months

    Hi All,

    I have company mobile billing report for the last 6 months which contains the following columns:

    Column A: Bill Issue Date
    Column B: Mobile Number
    Column C: Mobile Data Consumption

    The mobile number and data consumed value appear for each of the last 6 months.

    I need the 'Mobile Data Consumption' reported for each mobile number for the last three months in the following format:

    Mobile Number Month 1 Month 2 Month 3
    12345 200 500 300
    67890 100 800 900

    Example spreadsheet attached.

    Any help is greatly appreciated!
    Last edited by janjmi; 03-26-2020 at 11:10 AM. Reason: Formatting

  2. #2
    Registered User
    Join Date
    03-26-2020
    Location
    Australia
    MS-Off Ver
    O365
    Posts
    2

    Re: vlookup to return value based on previous months

    Attached example.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,783

    Re: vlookup to return value based on previous months

    I think you need a sumifs formula
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1