+ Reply to Thread
Results 1 to 4 of 4

Format Data from Table

  1. #1
    Registered User
    Join Date
    08-18-2017
    Location
    Charlotte, NC, USA
    MS-Off Ver
    Microsoft 2016
    Posts
    74

    Cool Format Data from Table

    Hey everyone,

    Hoping I could get some help with pulling data from one table and pasting it in another with a different format. I'm thinking index match formula but I can't figure out the month-year format for the table.

    I've attached a sample for reference. The yellow cell is what I would like filled. Ideally, the formula would be able to pull data as it in imported on a regular basis, ie. Nov, Dec, 2021 Jan, etc.

    Let me know if I can clear anything up.

    Thanks again.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,602

    Re: Format Data from Table

    You can use this formula in C5:

    =IFERROR(INDEX($R:$R,MATCH(DATE(C$4,INT((SEARCH($B5,"JanFebMarAprMayJunJulAugSepOctNovDec")-1)/3)+1,1),$J:$J,0)),"")

    Copy across and down the upper table. For the percentages, you can use a similar formula in C22 - just change the $R:$R shown in red to $S:$S

    Hope this helps.

    Pete

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Format Data from Table

    Please try at
    C5
    =IFNA(VLOOKUP(--($B5&C$4),$J$2:$T$50,9,0),"")

    C22
    =IFNA(VLOOKUP(--($B22&C$21),$J$2:$T$50,10,0),"")
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-18-2017
    Location
    Charlotte, NC, USA
    MS-Off Ver
    Microsoft 2016
    Posts
    74

    Re: Format Data from Table

    fantastic - both formulas work.

    Thank you very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 10-23-2017, 08:37 PM
  2. Replies: 0
    Last Post: 08-13-2015, 06:23 AM
  3. pivot table compare current data with refresh data and format new values
    By verynewatthis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2014, 08:29 AM
  4. [SOLVED] Extracting data from one table format and putting into a different viewing format
    By BeachRock in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-19-2014, 05:55 PM
  5. Replies: 0
    Last Post: 03-12-2013, 01:41 PM
  6. Replies: 3
    Last Post: 10-25-2012, 04:30 PM
  7. Data in Cross-Tab format: needs to be written in Table Format
    By runyan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2005, 03:05 AM

Tags for this Thread

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