+ Reply to Thread
Results 1 to 3 of 3

Google Sheets - VLOOKUP to Show No. Of Entries and Latest Entry

  1. #1
    Registered User
    Join Date
    04-23-2007
    Posts
    34

    Google Sheets - VLOOKUP to Show No. Of Entries and Latest Entry

    Hello all. I have a task that I know will involve a VLOOKUP formula but I'm not sure how to approach it.

    Example Google Sheet - https://docs.google.com/spreadsheets...it?usp=sharing

    In my data sample there 3 websites (red, green & blue) and 5 emails (john, jane, jimbo, peter & lisa).
    All 5 emails are registered on the 3 different websites totalling to 15 profiles (Profiles sheet).

    I then have an Orders sheet which lists orders - the website names and email addresses on the orders.

    On my Profiles sheet I have added 2 additional columns: Entries and Latest Entry.

    I would like Entries to total the number of times that profile appears on Orders (email and website column match) and Latest Entry to show only the latest order.

    EXAMPLE

    John Red - (Red Website, [email protected])

    John Red has featured 3 times on Orders:
    https://snipboard.io/4U1CrD.jpg

    Therefore, his Profiles columns should look like this:
    https://snipboard.io/JYTEZa.jpg

    If any new orders are added to the Orders sheet, I'd need these columns to update automatically.

    Thanks in advance for the help:

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Google Sheets - VLOOKUP to Show No. Of Entries and Latest Entry

    in cell Profiles!D2, enter this formula:
    Please Login or Register  to view this content.
    this one is an arrayformula so you do NOT need to drag down

    ---

    next, in cell Profiles!E2, enter this formula:
    Please Login or Register  to view this content.
    and drag it down.

    Screen Shot 2022-02-15 at 10.37.15 pm.png
    Last edited by janmorris; 02-15-2022 at 11:39 AM.

  3. #3
    Registered User
    Join Date
    04-23-2007
    Posts
    34

    Re: Google Sheets - VLOOKUP to Show No. Of Entries and Latest Entry

    This is great thank you for both solutions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Google Sheets] Get uniques IDs based on latest date
    By rolito in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 05-09-2021, 02:29 PM
  2. Google Sheets - Jump to last entry automatically
    By swvogt in forum Excel General
    Replies: 4
    Last Post: 08-30-2017, 02:53 PM
  3. Bold latest entry in cell and unbold remaining entries in the same cell
    By Parker4001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2016, 08:54 PM
  4. Populating raffle entries in Excel or Google Sheets
    By challenge_lead in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-26-2014, 11:18 AM
  5. Following the latest entry and the past 2 entries
    By khank in forum Excel General
    Replies: 4
    Last Post: 06-13-2011, 02:39 PM
  6. Vlookup The Latest Entry by Date
    By Christeen in forum Excel General
    Replies: 6
    Last Post: 05-05-2011, 07:29 AM
  7. Replies: 4
    Last Post: 04-27-2011, 05:08 AM

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