rollingzep
Board Regular
- Joined
- Nov 18, 2013
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hi,
I have two sheets on the same WB.
Sheet1 contains CUS_ID and MARKET_DESC. Sheet2 contains few fields like product, matdate ..... and ST
I need product from Sheet2 to look up the values of CUS_ID of Sheet1 and fill the ST field in Sheet2 with the values of MARKET_DESC from Sheet1.
Thanks
I have two sheets on the same WB.
Sheet1 contains CUS_ID and MARKET_DESC. Sheet2 contains few fields like product, matdate ..... and ST
I need product from Sheet2 to look up the values of CUS_ID of Sheet1 and fill the ST field in Sheet2 with the values of MARKET_DESC from Sheet1.
Test.xlsx | |||
---|---|---|---|
G | |||
11 | I | ||
Sheet2 |
Test.xlsx | |||
---|---|---|---|
D | |||
9 | |||
Sheet1 |
Thanks