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
Bookmarks