Help on using macro to filter out data

[Worldmarket]

I'll like somebody to help me out please. I have a sheet containing numbers in column A and names in column B. I have another sheet that is only containing numbers. I want to know if it is possible to use macro in looking up to the first sheet that has the numbers and the names so that i can match the names in the first sheet with their corresponding numbers in the second sheet.

e.g of my first sheet.


number name
111 michael
112 jessica
113 monica
114 camel
115 sentel
116 jupita
117 camer
118 zuma
119 hector
120 king
121 komn
122 zepra
123 jossy
124 hops
125 comt


e.g of my second sheet
number name
111
113
115
117
119
121
123
125
127
129

 

[texasalynn]

you don't really need a macro, use vlookup

Excel Workbook
	A	B
1	Number	Name
2	111	michael
3	113	monica
4	115	sentel
5	117	camer
6	119	hector
7	121	komn
8	123	jossy
9	125	comt
10	127	#N/A
11	129	#N/A
Sheet2

Excel 2003

Cell Formulas
Range	Formula
B2	=VLOOKUP(A2,Sheet1!A:B,2,FALSE)
B3	=VLOOKUP(A3,Sheet1!A:B,2,FALSE)
B4	=VLOOKUP(A4,Sheet1!A:B,2,FALSE)
B5	=VLOOKUP(A5,Sheet1!A:B,2,FALSE)
B6	=VLOOKUP(A6,Sheet1!A:B,2,FALSE)
B7	=VLOOKUP(A7,Sheet1!A:B,2,FALSE)
B8	=VLOOKUP(A8,Sheet1!A:B,2,FALSE)
B9	=VLOOKUP(A9,Sheet1!A:B,2,FALSE)
B10	=VLOOKUP(A10,Sheet1!A:B,2,FALSE)
B11	=VLOOKUP(A11,Sheet1!A:B,2,FALSE)

 

[cb12]

Seems like VLookup or Match/Index would do the job without the need to use a macro.

Assuming they are called "Sheet1" and "Sheet2" and you're starting in A1 then in Sheet2!B2 input the following formula: =VLOOKUP(Sheet2!A1,Sheet1!A1:B20,2,FALSE) and then copy as far down as necessary.

Hope this helps

 

[Worldmarket]

I appreciate your help. But I am still having a problem. the data in sheet two numbers in sheet two were randomly selected out of many numbers and names in sheet one. I tried what you guys wrote but some were giving me wrong names.

 

[texasalynn]

the data that you are using to lookup must be sorted in ascending order on the number