Matching a name to a specified monetary amount

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format monetary amount to 9 digits with No decimals without rounding 4
To be able to Total amount of occurrences in a dropdown list & total costs 0
adding up time over & under a specified amount 3
Sum If function 3
Naming cells 2
product code a value 0
CountIf value 3
SUMIF 2

Back
Top