I am trying to use VLOOKUP in a table with drop down data for Dollar amounts and Time interval to calculkate a Projected Annual dollar amount for the fund-raiser of a non-profit that I have volunteered to help. As a VLLOKUP Rookie, I'm not sure how to arrange the columns in the Table array. I'm also need a formula to change a text entry for the Time interval to a numerical value to be able to calculate the Projected Annual value.
Can anyone help me with this?
Have you done any work in setting up your workbook? If so, please attach a sample so we can work on solutions using your own data. Remember to remove/replace any sensitive info before uploading the file.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Thanks,tuph.
In the attached file, The Report worksheet will be the data entry sheet; assume Column A to represent several data columns, here just labeled to represent same. The interval and Amount columns will have drop down data as shown in the same columns in the Calculations worksheet.
The calculations worksheet contains the column labels and the text and numerical data that I will use to calculate the Projecvted Annual dollar amount.
Column lengths will have room for 1000 entries.
This is what I have set up at present; I appreciate your offer to help.
The following formula will work, providing the Data Validation is properly applied:Here is a copy of your file with the formula and data validation applied:
Please Login or Register to view this content.
Copy of Donation calculatuions.xlsx
Let me know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
JeteMc,
Thanks for your help. Looks good and works well. I am grateful for your help.Thanks
Your Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. Hope that you have a good day and GO DAWGS.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks