ItalianPlatinum
Active Member
- Joined
- Mar 23, 2017
- Messages
- 400
- Office Version
-
- 2016
- 2010
- Platform
-
- Windows
Hello - Running into a head scratcher here. it seems easy but I am having trouble putting all the pieces together and hoping someone could help. I condensed my large data set into one tab for ease as a sample
- I have VBA code that will run 1 days worth of data if B11 = B12
- If B11 doesnt equal B12 then it will run for 2 sets of dates; once for B11 and once for B12. So duplicates will generate.
- Formula I am looking for is to lookup the price of a identifer where if C is blank it uses B11 as the date to lookup and if C has a value it uses B12 as a lookup
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Date | Price | Fri/Sun | Indentifier | Today's Date | Indentifier | Price | |||
2 | 30-Oct | 10 | AAA | 30-Oct | AAA | Formula | ||||
3 | 30-Oct | 15 | BBB | 30-Oct | BBB | Formula | ||||
4 | 30-Oct | 20 | S | CCC | 30-Oct | CCC | Formula | |||
5 | 30-Oct | 75 | S | DDD | 30-Oct | DDD | Formula | |||
6 | 1-Nov | 20 | S | CCC | ||||||
7 | 1-Nov | 75 | S | DDD | ||||||
8 | 1-Nov | 10 | AAA | |||||||
9 | 1-Nov | 15 | BBB | |||||||
10 | ||||||||||
11 | Today's Date | 10/30/2020 | New Years Day | 1/1/2020 | ||||||
12 | Last BD - 1 or Holiday adjusted | 11/1/2020 | Martin Luther King, Jr. Day | 1/20/2020 | ||||||
13 | Washington's Birthday | 2/17/2020 | ||||||||
14 | Good Friday | 4/10/2020 | ||||||||
15 | Memorial Day | 5/25/2020 | ||||||||
16 | Independence Day | 7/3/2020 | ||||||||
17 | Labor Day | 9/7/2020 | ||||||||
18 | Thanksgiving Day | 11/26/2020 | ||||||||
19 | Christmas Day | 12/25/2020 | ||||||||
Data |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B11 | B11 | =TODAY()-1 |
B12 | B12 | =WORKDAY(TODAY(),1,F11:F19)-1 |