Hi
So, I have a list of rates associated to a person's age.
Now, in another sheet, I have a list of people of different ages and I have to put the rates to be used according to their ages.
How do I proceed ? Thanks.
Hi
So, I have a list of rates associated to a person's age.
Now, in another sheet, I have a list of people of different ages and I have to put the rates to be used according to their ages.
How do I proceed ? Thanks.
Through using VLOOKUP - i.e. put the following formulas into each of the cells noted in Sheet2...How do I proceed
D2: =VLOOKUP($C2,Sheet1!$A:$D,2,FALSE)
E2: =VLOOKUP($C2,Sheet1!$A:$D,3,FALSE)
F2: =VLOOKUP($C2,Sheet1!$A:$D,4,FALSE)
...and fill them down to row 1,391.
Note one employee (Employee272) is returning #N/A as their age (71) is outside the ANB in column A of Sheet1.
Regards,
Robert
Last edited by Trebor76; 10-18-2015 at 02:12 AM.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks