lookups

[Keith]

I am needed a little help. I am trying to use a lookup
statements that copies values out of one spread sheet over
to another. How do I do this? The numbers I am trying to
move from one location to another are values. So a simple
copy/paste does not work. I have to do a special paste
and choose value.

Keith

 

[JulieD]

Hi Keith

what's the criteria for moving the numbers over? (with a lookup function you
need to have something to look up)
by spreadsheet do you mean within a workbook (sheet 1 has numbers and you
want these on sheet 2)?
if the numbers in the first place change, do you want to see the change in
the second place?

if you're like to provide a few more details, then we'll do our best to
assist.

Regards
JulieD

 

[Guest]

Hi Julie

Thanks for your help so far.

Yes. I am trying to move data from sheet 2 to sheet 1 and
the data on sheet 2 changes all the time, and I want the
new data to so up on sheet 1.

Keith

 

[JulieD]

Hi Keith

what's the criteria for duplicating the data on sheet 2 on sheet 1?

if it's all the data on sheet 2 that you want to see on sheet 1 then a
formula will do it for you
cell A1 on Sheet1
=Sheet2!A1
fill down & across as needed

however if there's some criteria / summing / whatever i'll need a few more
details before i can come up with any solutions.

Cheers
JulieD

 

[Keith]

Hi Julie,

Okay here is the formula I am using in in the colum I what
to move from sheet 2 to sheet 1

=INDIRECT(CONCATENATE("A",MATCH(I2,INDIRECT(F2):INDIRECT
(G2),0)+D2-1))

So I need to show the value that is created from the
formula above on sheet 1, as a value not a REF.

Thanks
Keith