Hi all,
New to the forum, so please forgive any newbie mistakes.
I have a list of 40,000 unique part numbers, and a seperate database of 500,000 part numbers.
The database has many duplicate part numbers, split by Plant (Ownership). The Part/Plant combination on each row is unique, and other columns in that row contain unique information, i.e. Demand and Sales.
To illustrate the database:
<tbody>
</tbody>
What I would like to do is use my list of parts, and look them up against the database. However - as their are duplicate part numbers (see above), I would like to return only rows beloning to Plant B; BUT if Plant B does not exist for that part number, I would like it to return Plant A, and so on. I'd like this like a normal VLOOKUP, so I can return values further along the row, such as Demand Value and Sales.
Basically, I want a priority lookup, returning values based on a hierarchy of plants.
I would also like these to be interchangable, i.e.
<tbody>
</tbody>
Thanks,
Ed
New to the forum, so please forgive any newbie mistakes.
I have a list of 40,000 unique part numbers, and a seperate database of 500,000 part numbers.
The database has many duplicate part numbers, split by Plant (Ownership). The Part/Plant combination on each row is unique, and other columns in that row contain unique information, i.e. Demand and Sales.
To illustrate the database:
Part No | Plant (Owner) | Demand Value | Sales |
1 | A | £10,986 | £9,401 |
2 | B | £8,098 | £4,871 |
3 | A | £27,856 | £33,401 |
2 | C | £50,605 | £11,398 |
2 | A | £7,096 | £7,984 |
4 | B | £46,873 | £56,012 |
<tbody>
</tbody>
What I would like to do is use my list of parts, and look them up against the database. However - as their are duplicate part numbers (see above), I would like to return only rows beloning to Plant B; BUT if Plant B does not exist for that part number, I would like it to return Plant A, and so on. I'd like this like a normal VLOOKUP, so I can return values further along the row, such as Demand Value and Sales.
Basically, I want a priority lookup, returning values based on a hierarchy of plants.
I would also like these to be interchangable, i.e.
IMPORTANCE | PLANT |
1 | B |
2 | A |
3 | C |
<tbody>
</tbody>
Thanks,
Ed
Last edited: