I am looking to shorten a list of televisions based on which is the best value for money using criteria from a list. The televisions increase in value going down my spreadsheet by only a few euro but some have much better features than others.

Normally I take the first 10 and compare them, I choose based on Size, Brand, Features etc then I highlight the one I think is the best value in blue.

Can this be automated with a formula ?
I was thinking assigning weighted values to the criteria and then running some kind of comparison formula?
Is this the best way to tackle this issue?

Example:

SheetA has our Tvs and

A1 - Sony 50", LED
A2 - Panasonic 30" LED
A3 - Phillips 24", USB, HDMI
A4 - Generic Brand, 100"
A5 - Sony 10"
.
.
A10 - LG 30" USB, HDMIx2

sheet B has our criteria to compare & assigned weights

A1 - 20" #Assign a weight of 0
A2 - 30" #Assign a weight of 1
A3 - 40" #Assign a weight of 2

B1 - CRT #Assign weight of 0
B2 - TFT #Assign weight of 1
B3 - LED 'Assign weight of 3