Excel - Help!

Solved/Closed
The_g - Apr 1, 2011 at 10:08 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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.



1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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