X
xlsxlsxls
Hi,
I have a Workbook with 2 sheets. The first sheet is called "SearchData
and has 2 columns:
Name Code
Art 10
Ben 11
Carl 12
Doug 13
Eric 14
Fran 15
Gus 16
Henry 17
Irene 18
The second sheet is called "New" which has one column of names (o
which 5 are in the previous sheet).
Name
Allen
Bruce
Carl
Dana
Eric
Fran
Gary
Henry
John
Manually typing a formula using match and vlookup functions returns th
following desired result. (Note: Search data has to be sorted and uniqu
values only)
The formula is (which is searching for a match and if there is, return
the data in colum 2 or returns "Not Found"
=IF(ISNA(MATCH(A2,source!A:A,0))=FALSE,VLOOKUP(new!$A2,source!$A$1:$B$10,2,FALSE),"No
Found")
Then I fill down and get the desired result.
Name Code
Art 10
Bruce Not Found
Carl 12
Dana Not Found
Eric 14
Fran 15
Gary Not Found
Henry 17
John Not Found
In actuality, there will be thousands of records and I would like to b
able to attach this to a Button w/ a VBA Loop command with a message bo
saying done when complete. Problem is I am not very good at writing cod
and when I entered my formula in a module and tried to include shee
names it got all screwed up. I know it has something to do with D
While / Loop While the active cell in "New" is not empty. Any hel
would be appreciated.
Thank
I have a Workbook with 2 sheets. The first sheet is called "SearchData
and has 2 columns:
Name Code
Art 10
Ben 11
Carl 12
Doug 13
Eric 14
Fran 15
Gus 16
Henry 17
Irene 18
The second sheet is called "New" which has one column of names (o
which 5 are in the previous sheet).
Name
Allen
Bruce
Carl
Dana
Eric
Fran
Gary
Henry
John
Manually typing a formula using match and vlookup functions returns th
following desired result. (Note: Search data has to be sorted and uniqu
values only)
The formula is (which is searching for a match and if there is, return
the data in colum 2 or returns "Not Found"
=IF(ISNA(MATCH(A2,source!A:A,0))=FALSE,VLOOKUP(new!$A2,source!$A$1:$B$10,2,FALSE),"No
Found")
Then I fill down and get the desired result.
Name Code
Art 10
Bruce Not Found
Carl 12
Dana Not Found
Eric 14
Fran 15
Gary Not Found
Henry 17
John Not Found
In actuality, there will be thousands of records and I would like to b
able to attach this to a Button w/ a VBA Loop command with a message bo
saying done when complete. Problem is I am not very good at writing cod
and when I entered my formula in a module and tried to include shee
names it got all screwed up. I know it has something to do with D
While / Loop While the active cell in "New" is not empty. Any hel
would be appreciated.
Thank