Matching a name to a specified monetary amount
 

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.

Matching a name to a specified monetary amount
 

Sarah,
You need a table of names and corresponding hourly rates then
you can use VLOOKUP to get the rate for a name.

Assume names and rates are in columns A & B of Sheet2. Name the range (say)
"HourlyRates".

on Sheet1 with A1=Name, in B1 put:

=IF(ISNA(VLOOKUP(A1,HourlyRates,2,0)),"Name not
found",VLOOKUP(A1,HourlyRates,2,0))

HTH


"Sarah S" wrote:

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.