PDA

View Full Version : Need help pulling info from a list



akers77
12-05-2013, 01:58 PM
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

mancubus
12-06-2013, 02:17 AM
hi. try this widely used ARRAY FORMULA in C4, copy down to C7, in input sheet. you can change 5000's in ranges :
=INDEX($C$2:$C$5000,MATCH(1,(J3=$A$2:$A$5000)*(K3=$B$2:$B$5000),0))