Ninjababy1123
New Member
- Joined
- Jan 27, 2015
- Messages
- 5
Good Morning,
I am trying to combine a vlook up with an if statement
Here is my table
PLC Rate 1 Starting Date Ending Date Rate 2 Starting Date Ending Date
60 44.94 9/25/2012 12/2/2012 45.04 12/3/2012 9/24/2013
61 62.57 9/25/2012 12/2/2012 62.67 12/3/2012 9/24/2013
62 47.8 9/25/2012 12/2/2012 47.9 12/3/2012 9/24/2013
63 93.86 9/25/2012 12/2/2012 93.96 12/3/2012 9/24/2013
Here is my data
PLC Cd T/S Date
60 9/28/2012
60 9/28/2012
60 9/28/2012
60 9/28/2012
60 9/28/2012
60 9/28/2012
61 8/2/2013
61 8/23/2013
61 8/30/2013
61 9/6/2013
62 10/12/2012
62 9/28/2012
I need to vlook up the plc code and then incorporate the if statement for the date to pull back rate 1 or rate 2...any help would be greatly appreciated.
I am trying to combine a vlook up with an if statement
Here is my table
PLC Rate 1 Starting Date Ending Date Rate 2 Starting Date Ending Date
60 44.94 9/25/2012 12/2/2012 45.04 12/3/2012 9/24/2013
61 62.57 9/25/2012 12/2/2012 62.67 12/3/2012 9/24/2013
62 47.8 9/25/2012 12/2/2012 47.9 12/3/2012 9/24/2013
63 93.86 9/25/2012 12/2/2012 93.96 12/3/2012 9/24/2013
Here is my data
PLC Cd T/S Date
60 9/28/2012
60 9/28/2012
60 9/28/2012
60 9/28/2012
60 9/28/2012
60 9/28/2012
61 8/2/2013
61 8/23/2013
61 8/30/2013
61 9/6/2013
62 10/12/2012
62 9/28/2012
I need to vlook up the plc code and then incorporate the if statement for the date to pull back rate 1 or rate 2...any help would be greatly appreciated.