I need urgent help w/VLOOK UP PLEASE

[Excel ??]

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

 

[Sheeloo]

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 ??]

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?

 

[Excel ??]

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 -

 

[Sheeloo]

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 ??]

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

 

[Sheeloo]

here is my email id again -
(e-mail address removed)

replace id with to_sheeloo

(trying to avoid Spam)