Lookup names

[Babyyousif]

lets say i have two column in sheet 1 A is Names B is code of them in sheet 2 i have just names how can do below
1- check the names in sheet 1 with names in sheet 2
2- putting the codes of names in sheet 2
thanks

 

[Smitty]

Re: Bbayyousif

Welcome to the Board!

Take a look at VLOOKUP.

HTH

 

[Babyyousif]

Re: Bbayyousif

thank you but doesn't do what i need

 

[Babyyousif]

thank you for response
it doesn't work

 

[Smitty]

Re: Bbayyousif

thank you but doesn't do what i need

Then I suggest you give more details.

 

[Babyyousif]

Re: Bbayyousif

Sheet 1 Sheet 2
column A Column B Column A Column B
name code name Code
a 1212 a
b 520 c
c 310 f
d 905 d
e 2050 e
f 3010 b
above is the data in sheet 1 & sheet 2
what i need is
1- check all names in column A sheet 1 is in column A sheet 2
2- fill in column b sheet 2 the code of each name
i hope the example is clear
thanks

 

[Aladin Akyurek]

Re: Bbayyousif

In B2 of Sheet2 enter and copy down:

=VLOOKUP(A2,Sheet1!A:B,2,0)

 

[Babyyousif]

Re: Bbayyousif

thank you very much
really first doesn't work but when i change the column a to b & b to a it work

 

[Aladin Akyurek]

Re: Bbayyousif

thank you very much
really first doesn't work but when i change the column a to b & b to a it work

Forget not thanking Smitty to who urged you to look at VLOOKUP...

VLOOKUP matches A2 of Sheet2 against A of Sheet1 and returns a result from B of Sheet1... as you specified in post #6 .