I have been attempting to find the value in the sheet "Overview" in column A(storage location) that corresponds to the value in column C(ndc number). I am attempting to autofill the parts location on the sheet named "Orders". I am using the formula =VLOOKUP(H2,Overview!A:C,1,TRUE). It is not working the way I am expecting. What I need is if Orders!H2 = 1234 to find 1234 on Overview! and display the value of Column A on the line that contains 12345. The sheet named Orders, column K is where i need the formula. I have uploaded an anonymized version of the workbook. Any help would be greatly appreciated.
Inventory Tracking A.xlsx
Bookmarks