ExcelBanter - View Single Post

In article ,
says...
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

thanks to all that posted. it was a combo of the two that did the job.

also worked out a conditional format, if the date has past, it turns the
date BOLD RED. :-)

/CF