jim

[jim]

On worksheet 1 i select a month from a drop down list in
the form jan-04, feb-04, mar-04 etc etc


On worksheet 2 i have three columns:

Column A contains every item that is in the drop down list
in worksheet 1, i.e. jan-04, feb-04, mar-04 etc etc

Column B is a number for the relevant month, ie B1=1(as
this corresponds to January), B2=2, B3=3 etc etc

Column C is a text string that displays a range, ie C1=Jan-
04(as it is first), C2=Jan-04 - Feb-04, C3=Jan04 - Mar - 04
(as it is for the range Jan - Mar) etc etc etc


On worksheet 3 i want to be able to display:
1. The correct value from worksheet 2 Column B - based
upon selected value in worksheet 1 AND similarly
2. The correct value from worksheet 2 column C - based
upon selected value in worksheet1.


This problem cannot be solved with VLookup because its a
date i am lookin at, i have tried but it doesn't work, how
can i get round this?


Many thnx
Jim

 

[Andy B]

Hi Jim

Rather than bring back the information from the other sheet, you can use
Excel's formatting to do the job for you.
With Jan-04, as an Excel date, in A1 you can type =A1 in B1 and format this
as m (to give you the month number).
In C1 type =A1 and format as you wish. For the A2 and down use:
=TEXT($A$1,"mmm-yy")&" - "&TEXT(A2,"mmm-yy")

Hope this helps.