Checking limit values from separate xls file

[k0b0]

Hello to all experts on the forum!


I am looking for some kind of elegant solution for my Excel form. Let me describe in short the problem I am trying to solve.


At work I order different types of furniture (windows, doors, etc) and also all types of shades that go with different type of furniture. Since there are lots of different providers of the shades, there are also different limitations for each and every manufacturer. It has gotten to the point I cannot keep up with all the different requirements and limitations.


The ideal solution would be some sort of Excel formula/expression, that would check the provided dimensions of the furniture to the different xls tables (for each individual provider) with the limits of all kinds of different shades. If it is possible, i would like to select the providers from a drop down menu. I realize I would need to create additional xls files containing limitations for each provider separately, but that would be done just once and I am ok with that.


My ordering form for furniture looks something like this:


POSITION, WIDTH, HEIGHT, #, COMMENTS

P1, 100, 210, 1, text1

P2, 120, 120, 1, text2

P3, 100, 100, 1, text3

...


The crucial data are obviously WIDTH HEIGHT that would both need to be checked against the production limitations of specific manufacturer. I would like to use different XLS files for different manufacturer.


Example files:

https://www.dropbox.com/s/19amfjoqjqmsrzb/Form1.xls

https://www.dropbox.com/s/v0g54wt7nqklbud/Limits1.xls

https://www.dropbox.com/s/nyvdtwwitm655i6/Limits2.xls


Oh and I am using Excel 2003.


Any help will be greatly appreciated!


Regards,

B. Kos

 

[SirJB7]

Hi, k0b0!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


Thank you very much for uploading sample files. They're always very useful for people who read this and might be able to help you. But I think we have a problem here.


Your English's impeccable but I'm afraid that your workbooks not at all, as they're (I assume) in Czeck. I could understand first worksheet of them three and I didn't know where to run towards at 2nd (Vrata) and 3rd (Okna) worksheets.


Would you translate them (the header rows at least and a couple of examples), tell us what process you want to do with them and how do the data in those sheets get involved in the process of the solution, and re-upload the files? Thank you.


Regards!