cell w/ drop down then reference
In "Tracking" workbook C3 try the below formula
=index(Inventory!B:B,match(B3,Inventory!A:A,0))
If this post helps click Yes
---------------
Jacob Skaria
"Jackie" wrote:
K, I have a drop down box in "Tracking" workbook B3 with "Part Numbers".
When I choose one of the part numbers from that drop down box I want C3
("Current Balance") to update with a value from my "Inventory" workbook.
"Inventory" workbook only contains column A: "Part Number" & Column B:"Qty
in Stock"
|