Excel - Help! [Solved/Closed]

Report
-
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
-
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

Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
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