cell w/ drop down then reference

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

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"
 
In "Tracking" workbook C3 try the below formula

=index(Inventory!B:B,match(B3,Inventory!A:A,0))

If this post helps click Yes
 
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.
 
k, that works but when there's nothing in B3 ("Part Number") then C3
("Current Balance") is giving me a #N/A error which I understand why but can
i make that be blank when "part number" is blank?
 
Error handled version

=IF(ISERROR(match(B3,Inventory!A:A,0)),"",index(Inventory!B:B,match(B3,Inventory!A:A,0)))

If this post helps click Yes
 
Try one of these:

=IF(B3="","",VLOOKUP(B3,Invertory!A1:B1000,2,0))

Or, this more generic version:

=IF(ISNA(VLOOKUP(B3,Invertory!A1:B1000,2,0)),"",VLOOKUP(B3,Invertory!A1:B1000,2,0))
 
Back
Top