I have a crazy lookup to do and am not sure where to start.
Actually rewriting one of the sheets would be favourite but not practical.
In essence, I need to do a match and index, but the match is on a substring, which is where my problems start.
I have 2 sheets
so in the example below
258722 (in the tracker sheet) is looked up in the stockboard and found in E6 (2587224008) and 237 is returned
Is this possible?
Actually rewriting one of the sheets would be favourite but not practical.
In essence, I need to do a match and index, but the match is on a substring, which is where my problems start.
I have 2 sheets
- Order Tracker
- Stockboard
so in the example below
258722 (in the tracker sheet) is looked up in the stockboard and found in E6 (2587224008) and 237 is returned
Is this possible?
| Excel Workbook | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | Order Tracker Sheet | Stockboard | ||||||
| 2 | ||||||||
| 3 | Prodnumber | Order | Code | Order | ||||
| 4 | 729963 | 72996310951 | ||||||
| 5 | 318983 | 1876403937 | 213 | |||||
| 6 | 258722 | 237 | 2587224008 | 237 | ||||
| 7 | 187640 | 213 | VAN1876402549 | 53 | ||||
| 8 | 911191 | |||||||
| 9 | 258722 | |||||||
| 10 | 187640 | 53 | ||||||
| 11 | 362542 | |||||||
| 12 | 221634 | |||||||
Order Tracker | ||||||||
Last edited:
