vlookup to return value based on previous months

Hi All,

I have company mobile billing report for the last 6 months which contains the following columns:

Column A: Bill Issue Date
Column B: Mobile Number
Column C: Mobile Data Consumption

The mobile number and data consumed value appear for each of the last 6 months.

I need the 'Mobile Data Consumption' reported for each mobile number for the last three months in the following format:

Mobile Number	Month 1	Month 2	Month 3
12345	200	500	300
67890	100	800	900

Example spreadsheet attached.

Any help is greatly appreciated!

I think you need a sumifs formula