Hi - can anyone help with the if/ index/ match formula, to look up the rate for a given person for a given day of the week. Sample Data is attached data. If I have a sale person's name, how do I look up their rate for any given day?
Example: Example, I'm looking for a formula that returns 0.07 - Sarah Cooper's rate for Thursday's Sales - see attached. Thank you!
Try this....
Sarah Cooper Thur
F22=INDEX($E$5:$I$14,MATCH(E22&E23,INDEX($B$5:$B$14&$C$5:$C$14,)),MATCH(E24,$E$4:$I$4,0))
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
...or:
=SUMPRODUCT(($B$5:$B$14="Sarah")*($C$5:$C$14="Cooper")*($E$4:$I$4="THUR")*$E$5:$I$14)
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks