Creating a drop down list based on 2 cells that match

currently working with the first tab of my sheet, but will expand with the help of the forum to the other spreadsheets of my file.

I'm trying to create a drop down list in column q using the data in the table (CRQTY) that coincides with the pallet quantity in BC based on the part numbers in column R and BA matching if that makes sense

there are many different parts we ship with different quantities. so I basically want to have a drop down menu like I do in Q2-Q32 (these part numbers all have the same pallet quantity, so that was an easy data validation from 1 column of the CRQTY table)

LOL...I know it's a lot to look at. So I literally copy and paste info from our company's inventory (JD Edwards). Sometimes I keep the info in there if the parts shipping are the same on different days. Currently I have the first few customers having the q column have data validation list because all the parts we ship to those customers are all the same. For the other customers (the one that says OMMC and all the customers on the "Geri & Lekeya" tab all have different parts we ship to those customers with different pallet quantities. I would like to have a drop down list of those specific part numbers that match column R & BA.

For example, if R & BA match, I want a drop down that will show the multiples of that parts quantities

So if R & BA match with let's say HUB284T-9[ER03], I only want to pick from those multiples (each pallet is 162 PCs)

Originally Posted by Glenn Kennedy

I've looked at this for a few minutes and have absolutely no idea what is going on. You'll need to explain it... in BABY steps.

I'm trying to create a drop down list in column q using the data in the table (CRQTY)

I don't see an Excel table called "CRQTY"

So if the part is HUB284T-9[ER03], and the pallet is 162, you want multiples of 162 in the drop-down? How many multiples? Please give some specific examples, like, "If the part number is "ABC", the drop-down should show "100, 153, 210" (etc.)