Match with date to another sheet between dates

**Speshul** · 04-07-2016, 09:28 AM

Having trouble figuring this one out... Simple enough problem to describe and I feel like the solution will be pretty easy too:

I have is a list of codes, each with a corresponding date. There is a second list with another code I need to match back. The part that's getting me is the second list has a Start and End date which my first date must land between.

Sheet1: Two fields, Code and Date1
Sheet2: Four fields, Code, StatDate, EndDate, Code2

What I need to do is add the correct Code2 to Sheet1 where Date1 is between StartDate and EndDate

Hope that makes sense

Thanks

**djbomaha** · 04-07-2016, 10:35 AM

Hi Speshul,

The attached workbook is an example of what I think you were describing. Sheet 1 has the Code and Date1 columns. When Date1 is filled in, it triggers a macro to search for the corresponding Code2 if the date entered falls between a Start and End date on Sheet 2.

The way it is written, the Code needs to match and the date needs to be between the start and end dates for the Code2 to be copied.

Hope this helps,

Dan

**kvsrinivasamurthy** · 04-07-2016, 10:35 AM

Pl attach a sample file showing the required results.

**JohnTopley** · 04-07-2016, 10:42 AM

Try

=IFERROR(IF(AND(B7>=VLOOKUP(A7,Sheet2!$A$2:$D$50,2,0),B7<=VLOOKUP(A7,Sheet2!$A$2:$D$50,3,0)),VLOOKUP(A7,Sheet2!$A$2:$D$50,4,0),""),"")

Assumes data in A:C and A:D

Match with date to another sheet between dates

LinkBack

Thread Tools

Rate This Thread

Display

Match with date to another sheet between dates

Re: Match with date to another sheet between dates

Re: Match with date to another sheet between dates

Re: Match with date to another sheet between dates

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] increase count on tracking sheet based on date entry between dates in another sheet

[SOLVED] Match a date from a Table of dates, Help Please.

VBA to compare a date from one sheet to dates on second sheet of multiple similar people?

Setting a start date and end date for Index-Match within a list of dates

[SOLVED] index match a value if date falls between two dates

[SOLVED] Pay roll spread sheet - Match Dates

Date Match in all worksheets according to Main Sheet if not match insert row adjust

Bookmarks

Bookmarks

Posting Permissions