CF - I'm not sure what version of Excel you're using and I can't remember if
what I'm about to say is the same for all versions, but this works in 2003:

If you have a date centered across a number of merged cells, e.g. G1:H1 and
you want to have it also show in cell A1, then all you have to enter in Cell
A1 is the formula =G1, i.e the first cell in the merged cell range that
contains the date. The same is true if the merged cell range goes across
multiple rows as well as columns, e.g. if the range is G1:H5 (i.e. a merged
range of 10 cells), the exact same formula will work. In effect, you are
pointing to the cell in the top left of the merged range and Excel does the
rest. If you enter the formula =G1:H5 in cell A1, you will get a #VALUE error
as you're trying to tell Excel but put the contents of 10 cells into 1 cell,
and you can't do that with just an "=" sign.

Hope this helps.

Huw.

"Colonel Flagg" wrote:

i have a spreadsheet(s) that gives me a total for other sheets. done this
many times, the one thing i haven't done is generate a sheet that will
DUPLICATE a cell from another sheet exactly, without a "sum", etc.

i thought lookup would do it:

=LOOKUP("TEXT",'151a'!I1:J1)

that returns an N/A.

what i am looking to do is, have the exact same contents (it's a DATE)
that's in sheet 151a, cells i6:j1 be placed in the report sheet.

ideas?


/CF