"if" style question based on certain dates...

RobMarshall

Please read forum rules and post your thread in the correct forum
Programming forum is for VBA macro code type questions

Moving this thread to Excel Worksheet Functions forum

A thread with the rules is available at the top of each forum or see link below for rules

Hi guys,

Perhaps a poor choice in title, however, Im far from being an excel guru...

Heres my question:

There are three specific pathways of training (step by step) that a recruit into my organisation will go. These pathways are defined by when they were recruited. So I need a formula that will paste the training pathway, based on a certain date you may enter into a defined cell...

eg.

02/01/06 - 01/01/07 -> training pathway 1
02/01/05 - 01/01/06 -> training pathway 2
02/01/04 - 01/01/05 -> training pathway 3

In cell A2 I might type in the date 05/05/06 and then training pathway 1 will be copied and inserted from B2 across...

If you guys have any ideas how I might go about it I would be indebted.

Cheers



Edit:

I've attached an example of what I mean... Hope this helps.

hi Rob,

Please see the attached file for a couple of ways you could do this (may not be the best approach but I'm sure it will work).
(I run Excel 2003 & don't yet have access to the "converter" to open 2007 files, so I've just created a new example file.)

The "Using If" sheet is probably easier to interpret but is limited by the ability to nest If statments so I think that the "Using Sumproduct" sheet example will be better. the Sumproduct approach is more flexible for incorporating other "pathways" at a future stage (esp if you change the references to the Lookup Table to a dynamic named range)...

Note, my use of the vlookup on the sumproduct page is the quickest way (for me) of being able to provide a text field result after using sumproduct.

btw,
I've seen your question at each of the below links. Please try not to cross post, or if you do, please state that you are cross posting & give a link to the previous post.
http://www.excelforum.com/showthread.php?t=623510
&
http://www.excelforum.com/showthread.php?t=623507

hth
Rob

hey, no problem :-)

As long as the suggestions are helpful for you, it's all good!

Thanks for the feedback
Rob