Importing monthly data, want it matched to the corresponding row

[Fadelol]

Hi,

Every month we get a list of data that we import into a larger sheet. The monthly data very rarely matches the rows in the larger sheet. Currently we go through this manually row after row adding the correct monthly data for that row. I am however certain there must be easier ways of doing this.

Example:

A********B********C********D*****
NAME*****JUNE*****JULY*****AUGUST
BOB******45*******43*******94****
DENNIS***98*******54*******35****
CARL*****43*******22*******12****

Now say that we get the monthly report for September with the following data

NAME*****SEPTEMBER
BOB******99*******
MARK*****44*******

The desired result would be to have the 99 added to the E column in the larger sheet for BOB as well as having Mark added into the larger sheet. DENNIS and CARL who are not in the report for September can have their cells either as 0 or empty in the September column.

A********B********C********D**********E********
NAME*****JUNE*****JULY*****AUGUST*****SEPTEMBER
BOB******45*******43*******94*********99*******
DENNIS***98*******54*******35******************
CARL*****43*******22*******12******************
MARK**********************************44*******

I hope I made myself clear . Thank you for any help!

 

[VoG]

You should be able to use VLOOKUP for this http://www.contextures.com/xlFunctions02.html

If no match is found you will get #N/A