I am not sure if its a duplicate post.
I tried searching the forum, but couldn't relate it to the scenario I needed.
I have three sheet. named Sheet1, Sheet2 and Sheet3.
Sheet1 being the master sheet. What I want to achieve is:
I want to search for Name in sheet1 with the list of names in Sheet2,
If the name is found, then compare the Age in Sheet1 and Sheet2. If the age matches make an entry in Sheet3 "matched" else "didnt match".
If the name itself is not found on sheet2 , make an entry saying not found.
I am not sure what would be the best approach to solve the problem(formula/VB)...
Hope I am clear with my query...
Can you all please help ?
I tried searching the forum, but couldn't relate it to the scenario I needed.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Sheet1 | |||||
2 | Name | Age | ||||
3 | a | 10 | ||||
4 | b | 20 | ||||
5 | c | 30 | ||||
6 | d | 40 | ||||
7 | e | 50 | ||||
8 | ||||||
9 | Sheet2 | |||||
10 | Name | Age | ||||
11 | b | 20 | ||||
12 | c | 30 | ||||
13 | d | 40 | ||||
14 | ||||||
15 | Sheet3 | |||||
16 | Name | Age | ||||
17 | a | notfound | ||||
18 | b | matched | ||||
19 | c | matched | ||||
20 | d | didntmatch | ||||
21 | e | notfound | ||||
Sheet1 |
I have three sheet. named Sheet1, Sheet2 and Sheet3.
Sheet1 being the master sheet. What I want to achieve is:
I want to search for Name in sheet1 with the list of names in Sheet2,
If the name is found, then compare the Age in Sheet1 and Sheet2. If the age matches make an entry in Sheet3 "matched" else "didnt match".
If the name itself is not found on sheet2 , make an entry saying not found.
I am not sure what would be the best approach to solve the problem(formula/VB)...
Hope I am clear with my query...
Can you all please help ?