Hi Guys,

I have a table of data that contains a list of names in col A and then values in columns B to M (Jan - Dec).

On a separate sheet I am reporting the totals by name in a year to date (i.e. the total of all months with values in).

The way I would like to do this is by using the Offset function combined with a vlookup to 1) vlookup the name and 2) sum the values in the months

But I can not get it to work.

I think this may be because the Vlookup returns a value rather than a cell reference.

Can anyone advise?

Thanks for your time

bc