Tag Archives: Resistor Color Bands

From ‘Beginning Excel’: “HLOOKUP to Find Resistor Values”

From ‘Beginning Excel’ on WordPress we have an entry into the “VLOOKUP WEEK 2012” event that looks at HLOOKUP.

“Converting color bands to the equivalent resistance value is a good example of how table lookup function can be employed. Anyone can pick a separate color for every band through a drop-down list (built from data validation facility) and Excel matches color selected to the reference table, counts and displays the resistance value.” To Read More Click Here to go to Beginning Excel’s Lesson.