jeff_miller
New Member
- Joined
- Apr 7, 2005
- Messages
- 44
Looking for a formula in excel, was thinking of an IF with AND or VLOOKUP??
I have a database in Excel that has
A B C
1 9/1/98 8/31/00 RED
2 9/1/00 8/31/02 BLUE
3 9/1/02 8/31/04 GREEN
4 9/1/04 8/31/06 YELLOW
What formula would I use to take a Date (lets say its located in A8) and look up if it is BETWEEN the dates in column A and B above that it would give the result of column C
Examples
A8 = 11/07/99 would give the result of RED
A8 = 03/02/03 would give the result of GREEN
Thank You!
I have a database in Excel that has
A B C
1 9/1/98 8/31/00 RED
2 9/1/00 8/31/02 BLUE
3 9/1/02 8/31/04 GREEN
4 9/1/04 8/31/06 YELLOW
What formula would I use to take a Date (lets say its located in A8) and look up if it is BETWEEN the dates in column A and B above that it would give the result of column C
Examples
A8 = 11/07/99 would give the result of RED
A8 = 03/02/03 would give the result of GREEN
Thank You!