Hi,

I am stuckup up in using Vlookup & Sum Function.

Sheet 1
1 January 100
2 February 200
3 January 500
4 March 300
5 January 400


Sheet 2

We have columns of Month Name
January | February | March |

Whats required is
Under January auto summation should happen as 1000
Under February auto summation should happen as 200
Under March auto summation should happen as 300

Can anyone help.

Thanks in Advance.

Rgds

Akash Maheshwari