searchingforhelp
Board Regular
- Joined
- Nov 11, 2020
- Messages
- 67
- Office Version
- 365
- Platform
- Windows
Everyday data will be removed from Sheet2 Column A and replaced with new random data. As the year progresses so will the volume of data.
What I need help with:
Sheet1
Thanking you in advance for any help you can provide.
What I need help with:
- A formula that will look at the inventory number in Sheet2 Column A then;
- Locate that inventory number in Sheet1 Column A and B, then;
- In sheet2 Column B, identify the item (in this instance Apple/ Oranges
Mr Excel.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Inventory # | Category Apple/ Oranges | ||
2 | ERT-005656 | Apple | ||
3 | ERT-003030 | Oranges | ||
4 | ERT-007000 | |||
5 | ERT-003333 | |||
6 | ERT-002374 | |||
7 | ERT-007777 | |||
8 | ERT-004321 | |||
9 | ERT-004545 | |||
10 | ERT-007330 | |||
11 | ERT-002323 | |||
Sheet2 |
Sheet1
Mr Excel.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Apples | Oranges | ||
2 | ERT-004321 | ERT-003030 | ||
3 | ERT-007000 | ERT-002374 | ||
4 | ERT-005656 | ERT-004545 | ||
5 | ERT-003333 | ERT-007777 | ||
6 | ERT-007330 | ERT-002323 | ||
Sheet1 |
Thanking you in advance for any help you can provide.