Hi Everyone
I have a Userform (see attached) where on the 'Measurement' tab, I have a ComboBox called "RI Code" and a Text Box called Lot Size.
Once they choose the RI Code and enter in the Lot size, I would like to have the Sample Size and Reject Qty auto-populate from the table on the sheet called RI Code.
The RI Code Drop down has a list of
A1-A4, B1-B4, and C1-C4
The letter represents the sample size columns (B-D) and the numbers represent the Reject Qty columns (E-H)
So if A3 is chosen and the lot size is 14 the Macro would:
1. Look in column A to see if the lot size of 14 is less than or equal to any of the numbers and look across that row
2. While its looking across that row, it will search for the RI code of A3, and look for "A" first which is in column B and find that the "Sample Size" is 2 and enter that in the textbox.
3. While continuing to look across the same row and still searching for the RI Code of A3, it will look for "3" which is in column G and find the "Reject Qty" is 1, and enter that in the textbox.
I hope this makes sense. Its and index match type of look up with multiple variables
Thank you,
Abby
Bookmarks