Hi everyone,
I have attached a file that has my problem in a simple form.
I would like the drop down list in D15 to show only the house price values which are equal to or lower than that of the budget.
The budget currently shows 50 (cell A2) so i would like the drop down list to show 20 and 50 (eventually i will link it to the names to show the names rather than the budget. )
If i change the budget to 49 only the 20 should be in the list etc.
hope this is clear
thanks
Last edited by murchy; 10-29-2013 at 10:32 AM.
Lower on the list or as values?
100 is more(greater) than 50
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
hi Robert
sorry my typo, fixed it
I would like the list to replaced with the relevant values not added to it
thanks
MurchyHelp(1).xlsx
Please see attached,
There is a Named Range in the worksheet.
Hi Robert,
Your method seems to work perfectly, thank you!
I will attempt to copy it to my bigger project and get back to you if i get stuck
Hi robert, i was able to replicate your sheet on both the test document that i recreated and on my main project however I was wondering, in my main project I need to show house prices larger than that of the budget, i tried to change the sign here from<= to >= :
=IFERROR(INDEX($D$2:$D$10,SMALL(IF($D$2:$D$10>=$A$2,IF($D$2:$D$10<>"",ROW($D$2:$D$10)-ROW($D$2)+1)),ROWS($A$2:A2))),"")
but it doesnt work, i cant seem to find any other reference to greater than/less than
could you please indicate what I need to change to make it work
thank you in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks