Hi all, thank you in advance for your assistance.
I am preparing a product performance tracker for the business but I am having a lot of trouble with one little piece.
On Sheet 1 Column E I have a list of all the products. Sheet 1 Column I contains the Product Category. The category has 3 numbers then a series of letters. eg 057DINDINTRE. or 058LOULOUITY
On Sheet 2 Column b is the values I want to look up. eg 057, or 058, or 056 etc
What I need to happen is search Sheet1 Column I for a partial match of all the Sheet2 Column B and return the value from Sheet1 Column E to sheet 3 Column A. If Sheet1 Column I does not contain the 056,057 etc I need it excluded from the transfer to sheet 3.
The sheet 1 report changes every day as stock level increase and decreases, so I need sheet 3 to reflect these changes as well.
EG
Sheet 1 - Main report - Shows product and category, first three digits the key factor.
<tbody>
</tbody>
Sheet 2 - Reference list for above sheet to lookup
<tbody>
</tbody>
Sheet 3 - End result, all products from first list containing the first 3 digits listed in sheet 2 transferred to next page. The 025, and 090 products are excluded along with any other rows not listed in sheet 2, A1:A6. Notice that A1 and A5 below have the same group (057DREKIL), I need every record transferred providing the 057, 060 etc is met.
<tbody>
</tbody>
I sincerely hope this all makes sense. Thanks you one again.
I am preparing a product performance tracker for the business but I am having a lot of trouble with one little piece.
On Sheet 1 Column E I have a list of all the products. Sheet 1 Column I contains the Product Category. The category has 3 numbers then a series of letters. eg 057DINDINTRE. or 058LOULOUITY
On Sheet 2 Column b is the values I want to look up. eg 057, or 058, or 056 etc
What I need to happen is search Sheet1 Column I for a partial match of all the Sheet2 Column B and return the value from Sheet1 Column E to sheet 3 Column A. If Sheet1 Column I does not contain the 056,057 etc I need it excluded from the transfer to sheet 3.
The sheet 1 report changes every day as stock level increase and decreases, so I need sheet 3 to reflect these changes as well.
EG
Sheet 1 - Main report - Shows product and category, first three digits the key factor.
A | B | C | D | E | F | G | H | I | |
1 | Drill | 056HAMHGY | |||||||
2 | Hammer | 057DREKIL | |||||||
3 | Drill | 025HYGTED | |||||||
4 | Cage | 057GDEOIH | |||||||
5 | Nails | 060GTHKHF | |||||||
6 | Bolts | 090BOLYHG | |||||||
7 | Nuts | 090NUTGGG | |||||||
8 | Claw Hammer | 057DREKIL | |||||||
9 |
<tbody>
</tbody>
Sheet 2 - Reference list for above sheet to lookup
A | B | |
1 | 040 | |
2 | 042 | |
3 | 050 | |
4 | 056 | |
5 | 057 | |
6 | 060 | |
7 |
<tbody>
</tbody>
Sheet 3 - End result, all products from first list containing the first 3 digits listed in sheet 2 transferred to next page. The 025, and 090 products are excluded along with any other rows not listed in sheet 2, A1:A6. Notice that A1 and A5 below have the same group (057DREKIL), I need every record transferred providing the 057, 060 etc is met.
A | B | C | D | E | F | G | H | I | |
1 | 056HAMHGY | DRILL | |||||||
2 | 057DREKIL | Hammer | |||||||
3 | 057GDEOIH | Cage | |||||||
4 | 060GTHKHF | Nails | |||||||
5 | 057DREKIL | Claw Hammer | |||||||
6 | |||||||||
7 | |||||||||
8 | |||||||||
9 |
<tbody>
</tbody>
I sincerely hope this all makes sense. Thanks you one again.