Thread: Offset with Vlookup advice please

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

Hi,

How about using =MATCH() to identify the row, and then incorporating this MATCH() function in the INDIRECT bit of a SUM(INDIRECT()) function.

HTH

Hi Richard,

thanks for the tip. Ended up using the MATCH function with Offset and it works like a dream

Cheers

bc