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
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
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks