+ Reply to Thread
Results 1 to 2 of 2

Handling format year - week of year?

  1. #1
    Registered User
    Join Date
    06-29-2010
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    1

    Handling format year - week of year?

    Hello im Nils!

    Im working on excell files trying to make weekly reports easier to create by using vlookup on year and nr of week. The format our database uses is year - week of year (2007-05 = fifth week of 2007). But excell takes it for may of 2007... so when im trying to vlookup "2007-01" nothing is found because excell has formatted it to 2007-01-01, so its adding -01 to the end making vlookup not finding it.

    Even if i vlookup 2007-01-01 it doesnt find it because it shows in the cell as 2007-01 but in the field it still says 2007 - 01 - 01.

    So im wondering what to do? Can i loop the entire sheet with the database data and format it to text or? im supposed to be able to just paste the database data into an excell sheet and another sheet automatically updates tables and stuff..

    All the other fields has the format 2007 - 13 and is found by vlookup but not the first 12 weeks.

    Any ideas?

    And im using excell 2007 without vba.

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Handling format year - week of year?

    Try something like

    =VLOOKUP(LEFT(A2,7),rng,2,False)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1