Help with Price comparison / percentage change...

First off I would like to thank you guys on the form for being such a help. I have been the "go-to boy" at my new job, and couldn't have done it without you guys.

What I have is a cost analysis that compares. Our primary vendor's price is being compared to several other potential vendors. I used a formula to match the item number from multiple sheets and bring the price from that sheet over to a all index sheet that shows pricing for all the vendors in the row of a particular item. That formula looks like this: [I]=INDEX('mckesson alf'!M16:M74,MATCH('ALF Price Analysis'!A16,'mckesson alf'!A16:A74,0))
Now, I need to be able to create a new column that will show the percentage change between vendor A (our current supplier) and vendor B (a potential supplier).

for example
I need this Column:
Item # Description Vendor A price Vendor B Price Percentage change in price
ioh32332 Bandaid $3.44 $3.15 - 8.0 % or whatever


If you need any other information Please ask....I need to have this completed before the work day is over.
Thank you for your time!
God Bless!

Hello
The formula I would use to determine percentage change between Vendor A and B would be:

Please Login or Register  to view this content.

Format cell as percentage. If Vendor B is higher than Vendor A the result will be a negative percentage.

Hope this helps.
DBY