I have a spreadsheet built for quoting purposes. I have the names of the vendors that quoted with their pricing entered below them. I want to be able to compare between each vendor in percentages for each item that was quoted. I am stumped. Help

Welcome to the Board!

Offhand I'd think that VLOOKUPS might work for you, but why not attach your sheet (as a a .zip file) so we can all take a look an give you a better recommendation.

Smitty

THANKS

Something along thses lines?

Smitty

That helped me a lot, thanks