Lookup names

Babyyousif

New Member
Joined
Oct 8, 2018
Messages
12
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
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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
 
Upvote 0
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
 
Upvote 0
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 .
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,267
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top