Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All,
We have the following sheet
Sheet1,
Sheet2, from where we want to import data
We want the following
if Sheet1!C2:C4 is match with Sheet2!E3:E5 then in sheet1 we will get the data of that row
help pls
We have the following sheet
Sheet1,
Test.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Test | |||||
2 | 15016 | |||||
3 | 20479 | |||||
4 | 20659 | |||||
Sheet1 |
Sheet2, from where we want to import data
Test.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Head 1 | Head 2 | Head 3 | Head 4 | Head 6 | Head 7 | Head 8 | Head 9 | |||
2 | |||||||||||
3 | 6548965 | 1 | text | text | 20479 | 5000.00 | text | text | |||
4 | 94659823 | 5 | text | text | 65715 | 6000.00 | text | text | |||
5 | 3125544 | 8 | text | text | 32658 | 8000.00 | text | text | |||
6 | |||||||||||
Sheet2 |
We want the following
if Sheet1!C2:C4 is match with Sheet2!E3:E5 then in sheet1 we will get the data of that row
help pls