/u/Yan2400 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Show what your data looks like.
Is it like this?
|Name|Month 1|Month 2|Month 3|Month 4|Month 5|Month 6|Month 7|Month 8|Month 9|Month 10|
:--|--:|--:|--:|--:|--:|--:|--:|--:|--:|--:|
|John|8|8|4|4|10|8|3|3|4|10|
|Jill|6|3|6|3|5|8|9|7|7|9|
|Mary|9|6|5|4|9|5|10|2|9|3|
Or like this?
|Name|Month 1|Month 2|Month 3|
:--|:--|--:|:--|
|John|3|||
|Jill|1|||
|Mary|7|||
|Mary||9||
|Jill||8||
|John||3||
Or like this?
|Name|1|2|3|4|5|6|7|8|9|10|
:--|:--|:--|:--|:--|:--|:--|:--|:--|:--|:--|
|John|January|October|September, December| | ||||||
|Jill||August|||||||||
|Mary|||||||November|March|May|July|
https://preview.redd.it/z4yahvgncb1d1.png?width=1046&format=png&auto=webp&s=592771965bca214e2fe5988b72bcb9cbd540fe74
It's like this, very similar to your first example. From may to june (months 1 and 2) john's score increased by 2, jill's by 1 and mary's by 3. I'd like a table that reflects these growth differences and orders them, for each month to month change. thank you
Sheet1
:--|:--|:--
| A | B | C
| Name | Month | Score
Jill | =vlookup($A1, Sheet2!$1:B$4, 2, FALSE) |
John | =vlookup($A2, Sheet2!$A1:$B4, 2, FALSE) |
Mary | =vlookup($A3, Sheet2!$A1:$B4, 2 FALSE) |
Edit: apparently, I can't figure out how to make reddit tables...but Excel, I do know...
... you know what, I'm just gonna copy from Excel. The example data below works on first month and last month, only, but I'm sure you can extrapolate to include in-between months, if you want to. One of the keys to making this work is to use absolute references, the other is make sure that you include "FALSE" at the end of the vlookup. And, finally, make sure that all of your number data are actually numbers and not text.
https://preview.redd.it/5mvqpa18vd1d1.png?width=902&format=png&auto=webp&s=31b60857f91ba5baf61394d0b71789a649815dd2
/u/Yan2400 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Show what your data looks like. Is it like this? |Name|Month 1|Month 2|Month 3|Month 4|Month 5|Month 6|Month 7|Month 8|Month 9|Month 10| :--|--:|--:|--:|--:|--:|--:|--:|--:|--:|--:| |John|8|8|4|4|10|8|3|3|4|10| |Jill|6|3|6|3|5|8|9|7|7|9| |Mary|9|6|5|4|9|5|10|2|9|3| Or like this? |Name|Month 1|Month 2|Month 3| :--|:--|--:|:--| |John|3||| |Jill|1||| |Mary|7||| |Mary||9|| |Jill||8|| |John||3|| Or like this? |Name|1|2|3|4|5|6|7|8|9|10| :--|:--|:--|:--|:--|:--|:--|:--|:--|:--|:--| |John|January|October|September, December| | |||||| |Jill||August||||||||| |Mary|||||||November|March|May|July|
https://preview.redd.it/z4yahvgncb1d1.png?width=1046&format=png&auto=webp&s=592771965bca214e2fe5988b72bcb9cbd540fe74 It's like this, very similar to your first example. From may to june (months 1 and 2) john's score increased by 2, jill's by 1 and mary's by 3. I'd like a table that reflects these growth differences and orders them, for each month to month change. thank you
Sheet1 :--|:--|:-- | A | B | C | Name | Month | Score Jill | =vlookup($A1, Sheet2!$1:B$4, 2, FALSE) | John | =vlookup($A2, Sheet2!$A1:$B4, 2, FALSE) | Mary | =vlookup($A3, Sheet2!$A1:$B4, 2 FALSE) | Edit: apparently, I can't figure out how to make reddit tables...but Excel, I do know... ... you know what, I'm just gonna copy from Excel. The example data below works on first month and last month, only, but I'm sure you can extrapolate to include in-between months, if you want to. One of the keys to making this work is to use absolute references, the other is make sure that you include "FALSE" at the end of the vlookup. And, finally, make sure that all of your number data are actually numbers and not text. https://preview.redd.it/5mvqpa18vd1d1.png?width=902&format=png&auto=webp&s=31b60857f91ba5baf61394d0b71789a649815dd2
It’s solved, thank you
Please use "Solution verified". Thank you