+ Reply to Thread
Results 1 to 3 of 3

Match cell with latest corresponding data onto another page

  1. #1
    Registered User
    Join Date
    07-22-2023
    Location
    Melbourne, Victoria, Australia
    MS-Off Ver
    Microsoft 365
    Posts
    6

    Match cell with latest corresponding data onto another page

    I'm trying to reference the first value in one column and the corresponding info from another cell and then display that on another tab.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-22-2023
    Location
    Melbourne, Victoria, Australia
    MS-Off Ver
    Microsoft 365
    Posts
    6

    Re: Match cell with latest corresponding data onto another page

    I have attached an example file

  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,427

    Re: Match cell with latest corresponding data onto another page

    One way: Please try in B2 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. [SOLVED] Count Days Between Latest and Previous Data Match
    By clari55a in forum Excel General
    Replies: 27
    Last Post: 02-07-2024, 04:56 AM
  2. [SOLVED] automatically have a value from the adjacent cell from the latest data entry fill cell
    By Sriracha Iron G in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-22-2023, 02:23 AM
  3. [SOLVED] Copy Latest Date and Columns Data When Search Criteria Match
    By cyliyu in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-29-2023, 10:15 PM
  4. Index Match Match returning latest value
    By NBrown1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2014, 03:43 PM
  5. Replies: 9
    Last Post: 11-28-2013, 05:20 PM
  6. Replies: 9
    Last Post: 04-30-2013, 03:21 AM
  7. [SOLVED] Button which links the front page to another page depending on a data validation cell valu
    By greg19 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-12-2013, 03:59 AM

Tags for this Thread

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