Cell D2 needs to equal (A2*130%)+the bonus pp in column M that matches the week # in column C2
So I am thinking I could use index column M and match cell C and return that value in the equation, but is it possible?
Do I need to have another helper column? or can I do it within the equation itself? Would perfer the latter, as I am sure I could index match myself.
See attachment...Index plus Percent.xls
Last edited by 00Able; 02-02-2012 at 10:12 PM.
Providing Problems for Your Solutions
STARS are my Punching Bag, You will be rewarded.
In the rare event that I may help you, feel free to make me see STARS
maybe?
try vlookup instead
=(A2*130%)+VLOOKUP(C2,$K$3:$M$8,3)
and the values in d2 you've given, is it correct. i tried it manual but ????
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
Hi 00Able,
In D2 put this formula and pull it down
=A2*1.3+VLOOKUP(C2,$K$3:$M$8,3,FALSE)
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Wow didn't realize you could do that with Vlookup...Marvelous Marvin!
No, I changed the values, sorry for the confusion, but thank you Vlady!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks