Hi
I am trying to create a drop down list so that when the user choose Option A, Outcome A populates the cell.
So for example, I am looking to show a list of all Grades within the company, when the user selects a grade, the salary is populated into the cell.
Can someone help me regarding this?
Many thanks.
create a drop down list with a, b,c as the values for example
=IF(C2="a", 500, IF(C2="b", 600, IF(C2="c", 700, 0)))
this formula can be dragged down to fill the required cells
http://www.easyexcelanswers.com
Hi
I tried that but it kept coming as an error. To clarify I created a list in the Data validation area, and entered the formula in the Source box. When I okay'd it, it said that the formula I typed contained an error.
If you are trying for example to have a drop-down in A1 and have the selection in A1 generate a value that will be in A1, that isn't possible. If you want the value to be generated in another cell, that is possible by using a formula like that supplied by easyexcelanswers.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
example.xlsx
I have sent you an example
Thanks ever so much for the example, it worked wonderfully until.....
All was fine using the formula =IF(B2="AB",500,IF(B2="CD,500,0)) However, when I tried to use numbers where the letters are, it didn't work (eg IF(B2="1",600). How do I get it to accept numbers?
Thanks
To use numbers drop the Quotation marks ",
=IF(B1=1,500)
Re: How to create a drop list that populates the cell with some other data
Thank you all for your help. My problem has now been solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks