I need to determine an amount based upon two variable within a matrix, see attached file.
The first variable is the payee and the second is a different specific rate for each payee.
I need to determine an amount based upon two variable within a matrix, see attached file.
The first variable is the payee and the second is a different specific rate for each payee.
Based on your sample, try this...
=INDEX($G$1:$K$11,MATCH($B$3,$G$1:$G$11,0),MATCH($E$1,$G$2:$K$2,0))*$E$3
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
Thanks for the feedback
For future reference, please take a moment to mark the thread as "solved" using the THREAD TOOLS towards the top of the page - it helps keep things neat and tidy lol. I will do it for you this time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks