Excel - Help!

Solved/Closed
The_g - Apr 1, 2011 at 10:08 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 1, 2011 at 10:37 AM
Hello,

I require a formula which will recognise months in a column and select taht value from a different cell on the same row.

The data is then to be shown on a seperate worksheet.



Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 1, 2011 at 10:37 AM
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
0