Related:
- Excel - Help!
- Transfer data from one excel worksheet to another automatically - How-To - Excel
- How to change date format in excel to dd/mm/yyyy - How-To - Excel
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - How-To - Excel
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
1 reply
TrowaD
- Posts
- 2818
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 18, 2021
Hi The_g,
Use Vlookup on your seperate worksheet, let it look for the month in the month column, then enter the relative column number in which "a different cell on the same row" is located.
If this is unclear then please provide a sample of how your sheets look like or upload a sample of your workbook using a site like www.speedyshare.com. Also re-explain what you would like to see happen in more detail for better understanding.
Best regards,
Trowa
Use Vlookup on your seperate worksheet, let it look for the month in the month column, then enter the relative column number in which "a different cell on the same row" is located.
If this is unclear then please provide a sample of how your sheets look like or upload a sample of your workbook using a site like www.speedyshare.com. Also re-explain what you would like to see happen in more detail for better understanding.
Best regards,
Trowa
