Matching a name to a specified monetary amount
Sounds like you need VLOOKUP.
Here's an example of a VLOOKUP function in use: =VLOOKUP(7369,A1:B28,2,FALSE) This tells Excel to match the value 7369 with its corresponding record in the table contained in A1:B28, scan two columns to the right (i.e., Column B) and return the value in column B whose row corresponds to the value 7369 in the referenced table. And the FALSE argument tells Excel to look for an exact match. So, you need to set up a table with the employee's name and their rate. Then enter an employee's name in a VLOOKUP and have Excel return the hourly rate. Post back if you have questions. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "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. |
All times are GMT +1. The time now is 07:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com