Need help pulling info from a list

Hi,


I need some help pulling information from a list. The file is attached. On the "Input" tab, I have manually inputted color & serial #. This "List" tab contains a list of all serial number and color combinations.


I need help building a formula that can match the color and serial number input to the list and pull the appropriate " Amount Needed" from the "List" tab onto the "Input" tab.


Many thanks for the help!


-Andy

hi. try this widely used ARRAY FORMULA in C4, copy down to C7, in input sheet. you can change 5000's in ranges :

Code:

---

=INDEX($C$2:$C$5000,MATCH(1,(J3=$A$2:$A$5000)*(K3=$B$2:$B$5000),0))

---