Hi all I posted this in other but think this will be better to get an answer.
OK I have two worksheets in one excel spreadsheet. both different info but
some info is the same with each other like name of person but different sales
$ amount..anyway I need to merge both into one worksheet the names to match
etc..is this when the vlook up comes in place?? I can copy and paste but
that's going to take me years LOL its a huge list! Thank you so much - I
don't even know where to begin with this
--
2

Suppose you have a list of names in Col A of Sheet1 and
names in Col A & sales amount in Col B of Sheet2

You can use VLOOKUP to take the name in Col A of Sheet1, go down Col A of
Sheet2 to find the name, shift right to Col B to pick up the sales amount and
populate that in Col B next to the name.

Is that what you want?

Then enter this in B1 of Sheet1 and copy down
=VLOOKUP(A1,Sheet2!A:B,2,False)

"Excel ??" wrote:

Hi all I posted this in other but think this will be better to get an answer.
OK I have two worksheets in one excel spreadsheet. both different info but
some info is the same with each other like name of person but different sales
$ amount..anyway I need to merge both into one worksheet the names to match
etc..is this when the vlook up comes in place?? I can copy and paste but
that's going to take me years LOL its a huge list! Thank you so much - I
don't even know where to begin with this
--
2

Ok I'm still confused sorry - ok so I have two worksheets, I want to create a
master one with both integrated - both worksheets have same persons name like
example - worksheet 1 column A has peoples name - then worksheet 2 colum c
has same peoples name like these
Worksheet 1 Worksheet 2
Colum A Column C
1.Name 1. Name
2 John Doe 2. John Doe

But obviously in different order with different info except name I want to
match the names on each column to ONE WHOLE spreadsheet does that make sense?

--
2


"Sheeloo" wrote:

Suppose you have a list of names in Col A of Sheet1 and
names in Col A & sales amount in Col B of Sheet2

You can use VLOOKUP to take the name in Col A of Sheet1, go down Col A of
Sheet2 to find the name, shift right to Col B to pick up the sales amount and
populate that in Col B next to the name.

Is that what you want?

Then enter this in B1 of Sheet1 and copy down
=VLOOKUP(A1,Sheet2!A:B,2,False)

"Excel ??" wrote:

Hi all I posted this in other but think this will be better to get an answer.
OK I have two worksheets in one excel spreadsheet. both different info but
some info is the same with each other like name of person but different sales
$ amount..anyway I need to merge both into one worksheet the names to match
etc..is this when the vlook up comes in place?? I can copy and paste but
that's going to take me years LOL its a huge list! Thank you so much - I
don't even know where to begin with this
--
2

did you see my reply? can't see anything :-( I know what i'm trying to do is
simple to most but i'm plain confused thank you -
--
2


"Sheeloo" wrote:

Suppose you have a list of names in Col A of Sheet1 and
names in Col A & sales amount in Col B of Sheet2

You can use VLOOKUP to take the name in Col A of Sheet1, go down Col A of
Sheet2 to find the name, shift right to Col B to pick up the sales amount and
populate that in Col B next to the name.

Is that what you want?

Then enter this in B1 of Sheet1 and copy down
=VLOOKUP(A1,Sheet2!A:B,2,False)

"Excel ??" wrote:

Hi all I posted this in other but think this will be better to get an answer.
OK I have two worksheets in one excel spreadsheet. both different info but
some info is the same with each other like name of person but different sales
$ amount..anyway I need to merge both into one worksheet the names to match
etc..is this when the vlook up comes in place?? I can copy and paste but
that's going to take me years LOL its a huge list! Thank you so much - I
don't even know where to begin with this
--
2

You can get columns D, E etc. from sheet 2 to sheet1

Assuming first unused col in Sheet 1 is E
then put this in E1
=VLookup(A1,Sheet2!C:I,2,False)

You can get values from Col E-I from sheet2 to Col F-J by changing 2 to
3,4,...

If you are unable to get this then send the file to me. I will do the
needful tomorrow.

my id
to_sheeloo

add @hotmail.com to it


"Excel ??" wrote:

did you see my reply? can't see anything :-( I know what i'm trying to do is
simple to most but i'm plain confused thank you -
--
2


"Sheeloo" wrote:

Suppose you have a list of names in Col A of Sheet1 and
names in Col A & sales amount in Col B of Sheet2

You can use VLOOKUP to take the name in Col A of Sheet1, go down Col A of
Sheet2 to find the name, shift right to Col B to pick up the sales amount and
populate that in Col B next to the name.

Is that what you want?

Then enter this in B1 of Sheet1 and copy down
=VLOOKUP(A1,Sheet2!A:B,2,False)

"Excel ??" wrote:

Hi all I posted this in other but think this will be better to get an answer.
OK I have two worksheets in one excel spreadsheet. both different info but
some info is the same with each other like name of person but different sales
$ amount..anyway I need to merge both into one worksheet the names to match
etc..is this when the vlook up comes in place?? I can copy and paste but
that's going to take me years LOL its a huge list! Thank you so much - I
don't even know where to begin with this
--
2

I sent you email and got undeliverable
Hi
can you see this email, can you confirm. Well as much as I would love to
send you the doc I can't know I hate it because I need the help Badly but
here's an example I just cant figure this out and i'm dying over here



I have one excel spreadsheet of course two different tabs/worksheets both
have list of names I need to integrate that into one whole spreadsheet



like

sheet one sheet two

comlumn " "

A B

Name " "

John Doe John Doe
--
2


"Sheeloo" wrote:

You can get columns D, E etc. from sheet 2 to sheet1

Assuming first unused col in Sheet 1 is E
then put this in E1
=VLookup(A1,Sheet2!C:I,2,False)

You can get values from Col E-I from sheet2 to Col F-J by changing 2 to
3,4,...

If you are unable to get this then send the file to me. I will do the
needful tomorrow.

my id
to_sheeloo

add @hotmail.com to it


"Excel ??" wrote:

did you see my reply? can't see anything :-( I know what i'm trying to do is
simple to most but i'm plain confused thank you -
--
2


"Sheeloo" wrote:

Suppose you have a list of names in Col A of Sheet1 and
names in Col A & sales amount in Col B of Sheet2

You can use VLOOKUP to take the name in Col A of Sheet1, go down Col A of
Sheet2 to find the name, shift right to Col B to pick up the sales amount and
populate that in Col B next to the name.

Is that what you want?

Then enter this in B1 of Sheet1 and copy down
=VLOOKUP(A1,Sheet2!A:B,2,False)

"Excel ??" wrote:

Hi all I posted this in other but think this will be better to get an answer.
OK I have two worksheets in one excel spreadsheet. both different info but
some info is the same with each other like name of person but different sales
$ amount..anyway I need to merge both into one worksheet the names to match
etc..is this when the vlook up comes in place?? I can copy and paste but
that's going to take me years LOL its a huge list! Thank you so much - I
don't even know where to begin with this
--
2

here is my email id again -


replace id with to_sheeloo

(trying to avoid Spam)

"Excel ??" wrote:

I sent you email and got undeliverable
Hi
can you see this email, can you confirm. Well as much as I would love to
send you the doc I can't know I hate it because I need the help Badly but
here's an example I just cant figure this out and i'm dying over here



I have one excel spreadsheet of course two different tabs/worksheets both
have list of names I need to integrate that into one whole spreadsheet



like

sheet one sheet two

comlumn " "

A B

Name " "

John Doe John Doe
--
2


"Sheeloo" wrote:

You can get columns D, E etc. from sheet 2 to sheet1

Assuming first unused col in Sheet 1 is E
then put this in E1
=VLookup(A1,Sheet2!C:I,2,False)

You can get values from Col E-I from sheet2 to Col F-J by changing 2 to
3,4,...

If you are unable to get this then send the file to me. I will do the
needful tomorrow.

my id
to_sheeloo

add @hotmail.com to it


"Excel ??" wrote:

did you see my reply? can't see anything :-( I know what i'm trying to do is
simple to most but i'm plain confused thank you -
--
2


"Sheeloo" wrote:

Suppose you have a list of names in Col A of Sheet1 and
names in Col A & sales amount in Col B of Sheet2

You can use VLOOKUP to take the name in Col A of Sheet1, go down Col A of
Sheet2 to find the name, shift right to Col B to pick up the sales amount and
populate that in Col B next to the name.

Is that what you want?

Then enter this in B1 of Sheet1 and copy down
=VLOOKUP(A1,Sheet2!A:B,2,False)

"Excel ??" wrote:

Hi all I posted this in other but think this will be better to get an answer.
OK I have two worksheets in one excel spreadsheet. both different info but
some info is the same with each other like name of person but different sales
$ amount..anyway I need to merge both into one worksheet the names to match
etc..is this when the vlook up comes in place?? I can copy and paste but
that's going to take me years LOL its a huge list! Thank you so much - I
don't even know where to begin with this
--
2

Excel ?? wrote:
Hi all I posted this in other but think this will be better to get an answer.
OK I have two worksheets in one excel spreadsheet. both different info but
some info is the same with each other like name of person but different sales
$ amount..anyway I need to merge both into one worksheet the names to match
etc..is this when the vlook up comes in place?? I can copy and paste but
that's going to take me years LOL its a huge list! Thank you so much - I
don't even know where to begin with this

Please follow following steps
I am considering that you have two columns on sheet1 as name,sales ,,in sheet
2 there are also 2 columns as name and sales and are filled with date. Now as
far as i understand you roblem is that you want the sales values to appear
automatically on sales cell of sheet 1 for the related names between sheet1
and sheet2. If this is the case, then you can resolve the problem with
vlookup as follows:-
1.Click on the 'sales' cell on sheet 1
2.in the formula bar enter following formula
VLOOKUP(A1,Sheet2!A1:B4,2,FALSE)
3.apply to all the relevent cells below as well

You got it!

Have a happy time......





Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

Message posted via http://www.officekb.com