Last Price Paid: VLoopup? Index/Match?

**Excellerant** · 06-26-2012, 11:53 AM

Hi Guys,

I am new here and did some searching around on the forums and the internet and can't quite figure out to write this equation.

In short I am trying to write a summary equation on a tab that will tell me the last Purchase Price of a specific product. We order the same product from a variety of different suppliers. We might buy LLDPE from 3 or 4 different suppliers. All I am looking to do, is look at the last price I paid for a specific product.

I attached a section of the spread sheet so you can see how data is formatted. I've tried so VLoopups and Index/Match but I can't figure out the right combo.

**rob.barnes01** · 06-26-2012, 12:01 PM

Take a look at the attached file and see if it's doing what you need:

Sample- Resin Log.xls

Hope this helps.

**Søren Larsen** · 06-26-2012, 12:04 PM

How do you know which is the last purchase? Are they ordered chronologically? I see the same material LLDPE with the same PO# with different prices.

**Excellerant** · 06-26-2012, 12:25 PM

Rob- is working perfectly! I seriously tried something very similar but couldn't get it to work and got frustrated and gave up on it! -_-
One last question for you, is it possible to have the summary on a different tab? when I tried using the functioning to summarize the from another tab, it didn't seem to work.

This works flawlessly:=LOOKUP(4,1/($E$1:$E$1000=$O$107),$H$1:$H$1000)
I want to have a summary tab and I tried variations of:=LOOKUP(4,1/(CY_2012!$E$1:$E$1000=$B$51),CY_2012!$H$1:$H$1000)

O107 & B51 are the same item but in different cells on different pages!

Soren- Literally the last item in the column of a specific product type. Sometimes the PO#s reflect the same price, sometimes they're adjusted according to quality. (I changed the actual Purchase Price $ btw) =)

Thank you all for the quick responses!