LinkBack URL
About LinkBacks
I am creating a calculator based on a pricing menu. I am having trouble in a cell where a drop down menu offers options; 2,4,6,8,10 or 12. I would like the associated price for each option to be displayed in another cell.
I am creating a calculator based on a pricing menu. I am having trouble in a cell where a drop down menu offers options; 2,4,6,8,10 or 12. I would like the associated price for each option to be displayed in another cell.
Hi and welcome to the forum
Maybe this...
=VLOOKUP($C$21,Table1,2,0)
Assuming you want to find C21 in the table M9:N13
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
When I select "6" in C21 I would like the figure in C25 to change to "$3,600.00" and so on 4 through to 12. Maybe I have made my request a bit clearer... Thanks for your help!
????
=VLOOKUP(C21,Table1,2,FALSE)
Ben Van Johnson
LOL is there an echo in here Ben"
OK so put the suggested formulsa in C25
Ahhh, Pure Genius! Much hair pulling saved and brain starting to return to normal temp!!! thank you... I will develop the calculator along the same lines and hope that I can get the next features to work with this example...
you'r welcome, looking forward to assisting with the next question
Now at risk of sounding a total idiot; Is there a "solved" button? and where do I find it.
Please select Thread Tools from the menu link above the first post and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks