lookups

  • Thread starter Thread starter Keith
  • Start date Start date
K

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
 
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
 
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
 
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
 
Back
Top