Please help with vlookup function

[JMiller]

Hi,

I am trying to copy data from sheet1 to sheet2.
I cannot use the regular copy and paste function because if I make changes
on the sheet1, will not reflate on the sheet2.

So I decided to use "=Sheet1!A2".
I can easily from the sheet2 drag it down and have exactly the data from the
sheet1.
My problem is that I work with a lot of data is each sheet, so if I use the
above function, it will take me all day trying to finish my work.

My question is:
Is there any way, using the function "vlookup" that I can use to copy data
from sheet1 (the entire column - over 6000 cells) to sheet2?

Your help could be appreciated.

Regards,
J. Miller

 

[Max]

One basic functionality offered by vlookup or index/match (with the lookups
set for exact match) - vis a viz simple link formulae, is that these
functions allow you to maintain the same source data in various orders/views
across sheets, provided there is a key, unique data col (eg: product id,
staff id, etc) to lookup/cross-match these with.

Suggest that you try Debra's nice coverage
on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik

 

[mikerickson]

If you are using formulas, there has to be one formula in each receiving cell. The only question is:how fast is the formula.

=A2 is about the quickest formula there is.

 

[JMiller]

Hello Max,

Thanks for your suggestions.

One basic functionality offered by vlookup or index/match (with the lookups
set for exact match) - vis a viz simple link formulae, is that these
functions allow you to maintain the same source data in various orders/views
across sheets, provided there is a key, unique data col (eg: product id,
staff id, etc) to lookup/cross-match these with.

Suggest that you try Debra's nice coverage
on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik

 

[Max]

Welcome ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik