multiple criteria lookup formula

[scullymp_77]

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 ???

 

[Zack Barresse]

Hi scully, welcome to the board!!

Try these links, they should prove quite useful ...

http://www.mrexcel.com/board2/viewtopic.php?t=81341

http://www.mrexcel.com/board2/viewtopic.php?t=73376


I suggest a method from the first link, by Aladin.

 

[scullymp_77]

Thanks and I apologize for not being as clear as I should have been. I am looking for something that will only give me changes

Data Table Example:

Part | Price | Date
1B | 0.02 | 1/1
1B | 0.02 | 1/5
1B | 0.03 | 1/7
1B | 0.03 | 1/9
1B | 0.04 | 1/10
3B | 0.05 | 1/1
3B | 0.05 | 1/5
3B | 0.06 | 1/7
3B | 0.06 | 1/9
3B | 0.09 | 1/10

Anticipated Results:

Part | 1st Price | 2nd Price | 3rd Price | (Up to 8 Price Changes)
1B | 0.02 | 0.03 | 0.04
3B | 0.05 | 0.06 | 0.09

Any help would be greatly appreciated.