Filling Values by formula

[Mohandas]

I have 2 Sheets

1. MP
2. Brand NP

MP has the volumes of 2012 and 2013 data both in cases and tons

Tons data start with AM columns

I need to fill the Brand MP Sheet with 2012 and 2013 tons data month wise.

Please suggest me easy way.

Mohandas

 

[Abdul Matheen]

Hi Mohandas,

I have used some formula to get that the data, you can use vlookup and match formula to get the result or index and match. i have used vlookup and match formula only for couple of rows, check in the attached work book.

Regards
Abdul Matheen