+ Reply to Thread
Results 1 to 2 of 2

Looking through different lease dates (vlookup or index match?) to find the current tenant

  1. 01-15-2019, 03:43 PM #1
    tboutis
    tboutis is offline
    Registered User
    Join Date
    01-15-2019
    Location
    Toronto
    MS-Off Ver
    Windows 10
    Posts
    1

    Exclamation Looking through different lease dates (vlookup or index match?) to find the current tenant

    Hello everyone,

    So I have a list, with several columns, that lists our various leases and their date ranges. Some are for the same unit number.

    I am trying to create a formula (has to be on Google sheets) that is able to find the lease that falls on today's date (aka today is after the start date, and before the end date) and use a lookup to pull the current tenant. The issue is that there are several leases for the same units, and thus there are duplicates.

    I need a formula that locates a unit number, and then sorts through them to give me which one is current.

    See attached image for the layout of the sheet; picture duplicated number in the far left column.

    example.JPG
    Reply With QuoteRegister To Reply
  2. 01-15-2019, 06:17 PM #2
    ben_hensel
    ben_hensel is offline
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Looking through different lease dates (vlookup or index match?) to find the current te

    By duplicates, do you mean there are multiple leases in the same unit with overlapping dates, or just that completed leases are still listed, so that each unit has one-and-only-one tenant right now, but it includes people that used to rent it?

    If they overlap you're going to need something pretty exotic, but if it's a one-and-only one situation, it would be something like:

    Please Login or Register  to view this content.
    You'll need to post a spreadsheet (not just an image) to get specific code instead of pseudocode.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with index and match or vlookup to find data
    By mnsportsfan in forum Excel General
    Replies: 1
    Last Post: 12-21-2018, 02:10 AM
  2. Using VLOOKUP [ or INDEX (MATCH) ] to Find Two Separate Occurrences in an Array
    By Flannagan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2017, 10:09 AM
  3. Adding total by using vlookup or index and match to find the sum of an operation
    By jerr67 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2017, 02:14 PM
  4. Index Match to find match date to a range of dates
    By downcrusher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2017, 06:05 PM
  5. Using VLOOKUP or INDEX-MATCH to find greater than value
    By awhitworth in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-18-2015, 03:18 AM
  6. Vlookup does not find closest match (dates)
    By Stefan.hagnesten in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2009, 10:38 AM
  7. find all cells that match and use in an index/vlookup
    By Adam Bell in forum Excel General
    Replies: 1
    Last Post: 10-21-2005, 02:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1