Hey Guys,
Desperately need some help here. I have a column where I need to
- lookup a date and see if it falls in-between two dates displayed on another sheet
- Make sure the dates it is looking up are for the correct advertiser
What I need it to return is either 'Active" or "Previous IO" if the date does not fall in the range.
So in the example below I need to look up if the date on column 2 for 7/1/17 is an Active or under previous IO based on the date ranges in sheet 2.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="168"></colgroup><tbody>
</tbody>
In Sheet two I have this:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
I tried the following formula (that has more data) but this does not incorporate the advertiser lookup in it:
==LOOKUP(2,1/('Sheet 2'!B2:B14<=A1)/('Sheet 2'!C2:C14>=A1),'Sheet2'!G2:G14)
Test - Google Sheets
Thank you!!<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Desperately need some help here. I have a column where I need to
- lookup a date and see if it falls in-between two dates displayed on another sheet
- Make sure the dates it is looking up are for the correct advertiser
What I need it to return is either 'Active" or "Previous IO" if the date does not fall in the range.
So in the example below I need to look up if the date on column 2 for 7/1/17 is an Active or under previous IO based on the date ranges in sheet 2.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Date | Placement | Advertiser | Status |
2017-08-01 | PERSAV_Q1 | Macys | ? |
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="168"></colgroup><tbody>
</tbody>
In Sheet two I have this:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Advertiser | Start Date | End Date |
Macys | 8/1 | 8/31 |
<colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
I tried the following formula (that has more data) but this does not incorporate the advertiser lookup in it:
==LOOKUP(2,1/('Sheet 2'!B2:B14<=A1)/('Sheet 2'!C2:C14>=A1),'Sheet2'!G2:G14)
Test - Google Sheets
Thank you!!<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>