ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 293
- Office Version
- 365
- Platform
- Windows
how to filter sheet1 with the "include" criteria from multiple values (sheet 2: name).
basically if names from sheet 1 is available in sheet 2, then a formula in sheet 3 will extract the names/dept/group from sheet 1.
basically if names from sheet 1 is available in sheet 2, then a formula in sheet 3 will extract the names/dept/group from sheet 1.
Book2 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
3 | EXPECTED RESULT | ||||||||||||
4 | sheet 1 | sheet 2 | SHEET 3 | ||||||||||
5 | name | dept. | group | name | name1 | A | 1 | ||||||
6 | name1 | A | 1 | name1 | name2 | B | 2 | ||||||
7 | name2 | B | 2 | name10 | name3 | C | 2 | ||||||
8 | name3 | C | 2 | name7 | name7 | B | 2 | ||||||
9 | name4 | D | 1 | name3 | name8 | C | 1 | ||||||
10 | name5 | E | 1 | name2 | name10 | E | 1 | ||||||
11 | name6 | A | 2 | name3 | |||||||||
12 | name7 | B | 2 | name1 | |||||||||
13 | name8 | C | 1 | name7 | |||||||||
14 | name9 | D | 2 | name2 | |||||||||
15 | name10 | E | 1 | name8 | |||||||||
Sheet1 |