Cell Dependent on Drop Down Help
I cant seem to figure out how to have one cell update according to a drop down list.
What I have is say in cell 1a is a drop down with 10,15 and 20 yr warranty options. I need cell 3a to reflect the cost of the different warranties.
any help?
Thanks,
Joe
Last edited by shg; 04-13-2008 at 02:10 PM. Reason: title spelling
You can create a small table on the side somewhere and use Vlookup
e.g. =Vlookup(A1,X1:Y3,2,FALSE)
this will lookup value in A1 within range X1:X3 and return corresponding value from range Y1:Y3
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Have a look in this thread. (same issue)
There is an example of a sheet with the same requirements as you want in post #6
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
Portuga,
What thread are you refering to?
Apologies.
This one:
http://www.excelforum.com/showthread.php?t=640348
Post number 6
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks