Howdy All,

I'm having a problem with the hlookup function. I've used it before
successfully, but never before when the lookup_value in the array is in a
merged cell.

I have on one sheet a list of months. Each month is merged from 4 cells
into one and has 4 columns underneath it: the three leftmost columns are
data, and the 4th column is the total of the previous three columns. So far,
there are about 24 months.

What I want to do is have another sheet that lists each month, but has only
the total column underneath it. My problem is occuring when I paste the
formula over because the data that I want is occurs every 4 columns, so I
cant just past over.

Please let me know if this isn't clear enough.

Thanks!