scullymp_77
New Member
- Joined
- Feb 15, 2005
- Messages
- 5
I am trying to use a formula that acts similar to the vlookup formula to identify pricing changes when the same part is listed more than once.
EX-
Part | Price
1B | 0.02
2B | 0.01
1B | 0.04
2B | 0.01
1B | 0.03
2B | 0.01
I can use vlookup for Part 1B to find pricing of 0.02 . Is it possible to use a lookup formula Part 1B to find 0.04 and / or 0.03 ???
EX-
Part | Price
1B | 0.02
2B | 0.01
1B | 0.04
2B | 0.01
1B | 0.03
2B | 0.01
I can use vlookup for Part 1B to find pricing of 0.02 . Is it possible to use a lookup formula Part 1B to find 0.04 and / or 0.03 ???