I have a static chart on the left whose information I'd like to use for a function on the right. What formula would generate the appropriate "Money" value in the F column depending on which name is inserted in the E column?
Any help would be much appreciated.screen.png
Last edited by stk1990; 03-31-2016 at 01:46 AM.
Hi, welcome to the forum
take a look at using INDEX/MATCH for this
Last edited by FDibbins; 03-31-2016 at 01:48 AM.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks