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
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