Excel Help? information input to get a recommendation

January 9, 2015 at 07:08:36
Specs: Windows 7
I have to input 3 information about an exam room (whether a lab is needed, whether a sound system is needed and capacity range in class) all these will be done using data validation of (yes or no) and as for the capacity i will enter a set of ranges.After choosing the above information i should get a recommended room referring to a room sheet that i have done. Do you have any idea how can i use the match index or any lookup function and could you give and example? When i did the match and index it only gave a recommended room when the one is yes and the other is no yet if i choose another answer nothing pops up. Please help

See More: Excel Help? information input to get a recommendation

Report •

January 9, 2015 at 09:31:53
First, without knowing how your data is laid out, it would be impossible for us to offer any type of meaningful suggestions. We just don't have the details required to test anything or suggest anything.

There is a link at the bottom of this post. If you click that link you will see the instructions on how to post example data in this forum. Perhaps a short example of your data, including Row numbers and Column letters, would help.

Second, simply based on the text in your post, this almost seems like it will need some sort of "decision making" process where the result is based on the size of the facility, the equipment required, etc. Depending on how complicated that decision making process is, it might not be something that is doable with a formula. It might require some VBA code (a macro) which is much more adaptable when it comes to sorting through a list, using If-Then tests, etc.

Again, the more details we have the better chance we have of coming up with something.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question