Results 1 to 8 of 8

First instance based on information from a second table

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    Wisconsin
    MS-Off Ver
    Office 365
    Posts
    36

    First instance based on information from a second table

    Greets!

    I apologize for asking something that undoubtedly has been asked before. I can't come up with the right phraseology to ask the right question to get the right answer. I'm sure this will be an easy one for you.

    In the attached sheet, I'm looking for a formula that will give me the date of the first instance (I3:I12) from E3:E22. The info in B3:B22 is in another sheet in the real workbook. I need to do this without adding a helper column.

    Thanks in advance, I appreciate having Excel Forum as a place to get answers.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform: Add information into table based on row and column
    By Kyhosa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2019, 09:43 AM
  2. Move or delete cell information based on reference table
    By JW90 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2016, 02:06 AM
  3. Setup a Query in a Table Based on Information in that Table
    By lwflip in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-07-2015, 10:48 AM
  4. Replies: 3
    Last Post: 10-31-2013, 04:23 PM
  5. table automatically populates based on information in other tabs
    By ea223 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-27-2013, 10:10 PM
  6. Replies: 1
    Last Post: 01-13-2013, 06:04 PM
  7. Calendar based on varying information/ Pivot Table General
    By Neil in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-22-2005, 02:06 PM

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