Sounds like A1 should be a drop down box showing all the Names and B1 a Vlookup that looks at the value in A1 and returns the Rate from a Table.