jim

  • Thread starter Thread starter jim
  • Start date Start date
J

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
 
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.
 
Back
Top