I have the following data:

Table 1
Order # picks from Pool this Part #
777777 A1 123
666666 A2 456
555555 A3 789

Table 2
Part # has Qty in Pool
123 1 A2
456 2 A1
789 2 A3

I need a formula that tells me if the part is available from the pool where
the order will pick the part. I was thinking of a double VLookup but I don' t
know how to set up the formula. Perhaps using the IF function but still don't
know how to start.