Prolem with If and V lookup

Hi,

This is a bit difficult to explain. I am trying to paste a profile of how many days it will take to achieve something.

Which profile is used depends on 2 criteria, one a date field and the other a solution type i.e

Month 1 Month 2 Month 3 Month 4 Month 5
A 2 2 3 4 5
B 1 1 1 1 1
C 3 3 3 3 3
D 3 4 5 3 4

What I'd like to do is be able to select the solution type and then the start date and then the correct solution would be pasted into the following table at the correct place. i.e If the start date is 01/02/06 and solution A. The profile would put the month one figure against Feb-06 and then paste the rest of the profile against the rest of the year.

Solution start date Jan-06 Feb-06 Mar-06 Apr-06
A 01/02/2006 2 2 3

I've tried a number of things but cannot combine them all to work.

Any suggestions or a solution would be very helpful.

Thanks

Chris

Originally Posted by rimmerphant

Hi,

This is a bit difficult to explain. I am trying to paste a profile of how many days it will take to achieve something.

Which profile is used depends on 2 criteria, one a date field and the other a solution type i.e

Month 1 Month 2 Month 3 Month 4 Month 5
A 2 2 3 4 5
B 1 1 1 1 1
C 3 3 3 3 3
D 3 4 5 3 4

What I'd like to do is be able to select the solution type and then the start date and then the correct solution would be pasted into the following table at the correct place. i.e If the start date is 01/02/06 and solution A. The profile would put the month one figure against Feb-06 and then paste the rest of the profile against the rest of the year.

Solution start date Jan-06 Feb-06 Mar-06 Apr-06
A 01/02/2006 2 2 3

I've tried a number of things but cannot combine them all to work.

Any suggestions or a solution would be very helpful.

Thanks

Chris

would you please explain a little more with cell references your data resides in.

Hi,

Thanks for your interest in my query. I have now actually received a reply from another forum. The solution was to paste the formula below.


''=IF(DATE(YEAR($I4),MONTH($I4),1)>J$3,"",INDEX($B$3:$F$6,MATCH( $H4,$A$3:$A$6,0),COUNT($I4:I4)))"

Thanks again

Chris