Hello,

I have a spreadsheet where I'd like to be able to insert options onto the drop down menus on sheet 1. Based on the items I select, I would like it to then tell me what my sample size is and my accept or reject numbers are. All the requirements are on tab "Mapping". For example, if I have an AQL of .1 a lot size of 2 to 8, with a normal inspection type 1, I would have a sample size of 2 and an accept or reject rate of 0-1. I'm sorry, I'm sure this is very confusing. Any help is really appreciated. Thanks!

AQL Lookup Sheet-1.xlsx