Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
hi all,
we have the following two sheets
one is
second is
we want to check if from sheet 2, b2 or c2 any one value match with Sheet1!B2:E5 then it will copy the value from column Sheet2!A
result sheet is
help pls
we have the following two sheets
one is
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | |||||||
2 | USA | 01-02-2020 | 6740508 | tet@gmail.com | |||
3 | AUS | 01-02-2020 | 8521625 | usto@gmail.com | |||
4 | IND | 01-02-2020 | 0053313 | pos@gmail.com | |||
5 | NEW | 01-02-2020 | 2991119 | spam@gmail.com | |||
Sheet1 |
second is
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | |||||
2 | jk-556 | 7729900 | can@gmail.com | ||
3 | jk-554 | 7729902 | usto@gmail.com | ||
4 | jk-557 | 6740508 | bhub@gmail.com | ||
5 | jk-552 | 0053313 | |||
Sheet2 |
we want to check if from sheet 2, b2 or c2 any one value match with Sheet1!B2:E5 then it will copy the value from column Sheet2!A
result sheet is
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ||||||||
2 | USA | 01-02-2020 | 6740508 | tet@gmail.com | jk-557 | |||
3 | AUS | 01-02-2020 | 8521625 | usto@gmail.com | jk-554 | |||
4 | IND | 01-02-2020 | 0053313 | pos@gmail.com | jk-552 | |||
5 | NEW | 01-02-2020 | 2991119 | spam@gmail.com | ||||
Sheet1 |
help pls