I'm trying to convert a static parameter function into one that can be used with multiple values. Im having a hard time with this. It's kind of hard to explain so let me get down to it.
I have a function that I use to see if a table has a match with another table, but validating against 2...
I also tried using a 'labelControl' just to see if it would work, and that wasn't the answer. Just stating things I've tried
<labelControl id="label" label="Label Control" />
Im running 2016 Standalone Excel (32bit version). I've been building a custom ribbon and so far so good. The documentation is pretty fluid and well written. However, I cant find any way to include menu 'section titles' as seen below:
Furthermore, with my version of Excel, Menu with titles...
@bosco_yip @Hui I attached a working example. I'm going to keep working on it based on what bosco delivered. You don't have to combine both the formulas into one. I can handle that, I hope. I actually want to learn how to do it individually first. See attachment and let me know if it makes more...
Thank you! You are the best. Gez, this is the closest thing I've seen to a solid solution. There is an issue however, some associates won't have rooms for the day at all, so their respective Room row will be empty and B3 in your example will always be the person below the number given. So for...
This title is hard to convey my needs. I have a spreadsheet that uses named ranges to maintain dynamic control. I have a search box where user inputs text (can be number, but cell is formatted as general). When user inputs a number the LOOKUP() formula will search if an associate has the room...