Conditional VLOOKUP

[34sweetness]

I have a table that list part numbers and date ranges. Each part number has several date ranges associated with phases of a project.

I have a larger spreadsheet with cost data associated with the part numbers and am trying to add a column for each phase. So, if the date of the expenditure is with in a range related to a particular phase, I want to populate that row with the correct phase name.

I think I can use the VLOOKUP, but can't figure out how to place in the criteria relative to the date range.

Any suggestions?

 

[Robert Mika]

Woudl you care to post some data?

To post your data you can download and install two of the following programs:

HTLMaker

or
Excel Jeanie


or when using Internet Explorer just put a borders around your data in Excel and copy those cells into your post.

 

[34sweetness]

Table with date ranges for phases and part #: (Columns A-G/9 rows)

A B C D E F G
1 Phase 1 Phase 1 Phase 2 Phase 2 Phase 3 Phase 3
2 Part # From To From To From To
3 32 Jul-07 Sep-09 Sep-09 today n/a n/a
4 36 Apr-08 Sep-08 Sep-08 Nov-08 Nov-08 Sep-09
5 40 May-08 Aug-08 Aug-08 Jul-09 Jul-09 Aug-10
6 45 Jul-07 Jul-09 Jul-09 Mar-11 Mar-11 today
7 48 Apr-08 Aug-08 Aug-08 Mar-09 Mar-09 May-10
8 54 Jul-07 Jan-09 Jan-09 Dec-09 Dec-09 today
9 58 Jan-09 Mar-09 Mar-09 Jul-10 Jul-10 today

Cost Table that needs to be "populated" with "phase" (in column D):


A B C D
Part # Date Expense Phase?
1 32 1/1/2008 12.4
2 48 1/1/2009 81.86
3 48 1/1/2009 1476.24
4 54 1/1/2008 872.15
5 32 2/1/2010 3330.94
6 36 6/1/2008 1006.97
7 45 2/1/2008 607.94
8 45 2/1/2010 2613.74
10 58 2/1/2010 938.9

Does this help any?