Hi,
Can someone explain how to create a vlookup based on a drop down menu criteria?
I have provided a sample worksheet for illustration.
Thank you for the help!
Hi,
Can someone explain how to create a vlookup based on a drop down menu criteria?
I have provided a sample worksheet for illustration.
Thank you for the help!
see if the attached is what you want?
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 quick response. The cumulative totals are already inputted in the "Value" tab. I only need that value based on the drop down criteria (TO, Clin). for example, selecting TO 2 and Clin 1, gives 6000 for the value and 5000 for the funding. I attempted to revise the formula but didn't have any success.
Thank you! Thank you!
I figured out the problem. I didn't press ctrl+shift+enter... Still learning!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks