I have a pretty basic spreadsheet set up to calculate payroll for some of our temporary workers. I have a table of workers names and their pay rates in the lower right hand side of my worksheet.
Up until now I have been glancing over to determining their pay rate and manually entering that rate into a specific cell (I2) to start the pay calculations. What I would like to do is somehow add another column to the left of their names and place an "x" or something in that column for the specific employee I am calculating. Once the "x" is placed there I would conditionally format the employees name to be highlighted and have their wage entered into cell I2.
So what I need is a formula to enter into cell I2 which searches cells K5:K24 and when it finds an "x" it enters the payrol rate from the corresponding cell in the range of N5:N24
I know I could revamp my spreadsheet and make a drop down list of names and when a name is selected do a vlookup for the pay rate, but I am looking for a different and hopefully simpler solution.
Thanks, Spence
Bookmarks