cell w/ drop down then reference
Hi,
Try something like
=VLOOKUP(B3,Invertory!A1:B1000,2,False)
This example assumes we are refering to the worksheet Inventory not the
workbook, but it will work with a workbook also. In that case open both
files and with your cursor in C3 of Tracking type =VLOOKUP(B3,
and then click in the other workbook, and on the correct sheet, and then
highlight the necessary range and complete the formula as above.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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"
|