+ Reply to Thread
Results 1 to 4 of 4

Fetch data from 1 table and post in another table in same excel sheet after pivoting

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Question Fetch data from 1 table and post in another table in same excel sheet after pivoting

    I have a table as mentioned below:

    Name Age Income
    jks 20 40
    kjsj 21 80
    kjk 20 60
    kjdkj 22 40


    And i want my output to look like:

    Name/Age 19 20 21 22 23
    jks 20 40 8
    kjsj 40 80 16
    kjk 30 60 12
    kjdkj 20 40 8

    Where the values in the left and right row is 50% and 20% of the corresponding value.
    Please refer attached excel sheet for better preview

    Thanks in Advance
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,136

    Re: Fetch data from 1 table and post in another table in same excel sheet after pivoting

    welcome to the forum, Loveleen. 1 way is this in B8:
    =IF(ABS(VLOOKUP($A8,$A$2:$B$5,2,0)-B$7)<2,VLOOKUP($A8,$A$2:$C$5,3,0)*CHOOSE(VLOOKUP($A8,$A$2:$B$5,2,0)-B$7+2,0.2,1,0.5),"")

    copy down & across

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    12-03-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Talking Re: Fetch data from 1 table and post in another table in same excel sheet after pivoting

    [SOLVED] Thanks a lot. It works perfectly
    Last edited by Loveleen; 01-08-2014 at 12:55 AM.

  4. #4
    Forum Expert (Lazarus)
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    .
    Posts
    2,594

    Re: Fetch data from 1 table and post in another table in same excel sheet after pivoting

    OP seems to have forgot the cross post rule - perhaps he'll have the courtesy to update his other thread and let users on ExcelGuru know that the issue has been resolved.
    Last edited by cytop; 01-07-2014 at 06:14 AM. Reason: Silly typo

+ 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. [SOLVED] how to fetch data from a table on check event of a checkbox in excel vba
    By basubdd in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-28-2013, 02:52 PM
  2. How to Fetch a table values in a webpage to Excel sheet using VBA Macro??? Help Me
    By ParthibanPalaniswamy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2013, 05:08 AM
  3. Fetch data from Access table in Excelsheet in specific format
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-17-2012, 05:31 AM
  4. How to fetch the table from ASP web site and save in Excel
    By rajen87 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-05-2012, 01:47 PM
  5. Replies: 1
    Last Post: 02-27-2009, 03:18 PM

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