I need to find the formula that can match a specified monetary value to a name.
For instance if I type in A1 Name1 then in B1 $14.00 comes in or if I would
have typed in Name2 then $18.00 would pop in. I need this calculation to
automatically pop in someone's hourly pay by what name I put in. I think I
have to come up eith a simply pay chart to reference but I don't know where
to start.