LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default Problem Using Excel datenumber as Text reference

Hi, struggling here with Excels datenumber...

I have as source the following table:

2006 2007
Jan 10 12
Feb 8 9
Mar 9 11
etc...


As a destination I have a report stating the following:

Jan-07 12
Jan-06 10

Whereby my report uses the Microsoftdatenumber as a reference
throughout, where Jan-07 is 39083 with the use of Format Cells Date
...

This value will change according to the month we live in :-)

Now the problem is: how can I use this datenumber to look up the
according value in the crosstable?
Normally I use INDEX() or VLOOKUP for this.
However, if I try to get "Jan" as a lookupvalue, e.g. through (LEFT();
3), this obviously does not return "Jan" but "390".
Is there I way to do this, pref. without adding an extra, intermediate
worksheet?

Important backgroundinfo:
My sourcefile is not made the way I would have it, but due to
"userfriendlyness" (i.e. the user-skill-level) I cannot change that.

Hope my question is at least understandable ^^

Thanx in advance for any help!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Charts - Text Box Problem tpearo Charts and Charting in Excel 1 June 21st 06 04:14 PM
Started out as an Access problem. Now an Excel problem RobertM Excel Discussion (Misc queries) 2 April 26th 06 07:30 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Problem organizing text data into new excel page Tony Excel Worksheet Functions 3 October 21st 05 08:19 PM
Slight problem automating Excel in a service someone Setting up and Configuration of Excel 2 May 13th 05 10:04 PM


All times are GMT +1. The time now is 05:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"