View Single Post
  #1   Report Post  
Colonel Flagg
 
Posts: n/a
Default simple yet evading

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