Hi,
i created drop down with % and lookup on it.
the issue is that i have duplicate there:
Screenshot_133.png
How to based on list show appropriate result?
So first 8,5 % --> show Res1
Second 8,5 % --> show Res2
Best,
Jacek
Hi,
i created drop down with % and lookup on it.
the issue is that i have duplicate there:
Screenshot_133.png
How to based on list show appropriate result?
So first 8,5 % --> show Res1
Second 8,5 % --> show Res2
Best,
Jacek
One way would be to change the second 8.5 to 8.50000000001
it'll make no practical difference, but will enable VLOOKUP to return the correct answer.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
thank you Glenn.
It is to consider but lets wait if there is smarter solution.
Best,
Jacek
If the drop-down is prepared this way as it is at the moment (with Data Validation) I don't think it is possible.
Data validation just changes the value of E7 leaving no evidence which value from the list it is.
You could use dropdown created as combo box (from developer-insert-form controls). Then it displays values from the list, but in connected cell (I used cell under the combobox) it returns position f selected value on the input list. And of course you can use INDEX function in this case to find related value from second column.
See attached example
Best Regards,
Kaper
Thank you Kaper!
Best,
Jacek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks