Related:
- Excel - Help!
- How to change date format in excel to dd/mm/yyyy - How-To - Excel
- Formula bar not showing in excel - How-To - Excel
- How to change author in excel - How-To - Excel
- Transfer data from one excel worksheet to another automatically - How-To - Excel
- Spell number in excel 2007 indian rupees download ✓ - Forum - Office Software
1 reply
TrowaD
- Posts
- 2669
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 15, 2020
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
