i am having a hard time trying to get this to work past e7 & e6. with the formulas i have, i can get the correct values returned for e7 & e6 but not for the rest. I was instructed to use "if" and "vlookup" for the yearly pay value. any help would be appreciated!
PayRate.xlsx
What you want to do?
Maybe this:
=INDEX($B$4:$F$10,MATCH(PAY_GRADE,$A$4:$A$10,0),MATCH(YRS_OF_SRVCE,$B$3:$F$3,0))
Last edited by zbor; 02-17-2012 at 04:07 AM.
Never use Merged Cells in Excel
user input pay grade, years of service and i want it to display the annual total
See attached file, I think this is what you need
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
did you tried zabor's formula??
that's the formula will do... just add *12 to the end if you want annual..
@ zabor's formula
==INDEX($B$4:$F$10,MATCH(PAY_GRADE,$A$4:$A$10,0),MATCH(YRS_OF_SRVCE,$B$3:$F$3,0)) *12
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
i was told to use IF and VLOOKUP to find the answer. i can get the first two(e7~6) but if i continue my code down to e5~1 i get wrong values. all the feedback so far gets me the right answers but i am trying to figure it out using IF & VLOOKUP.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks