Lookup from multiple cells on different sheets

please see attached sheet, there are 2 sheets on this file, one named production report and the other bulk totes.
what i am looking to do is when i add a product code to the column on 'production report calc' sheet, it looks up the codes listed on the 'Bulk Totes' sheet (Both Column A) and then it looks at the 'Ammount to fill column on the 'Bulk Totes' sheet and enters the amount into the 'BULK lVL' column on the 'Production Report CALC' sheet.

for example on the sheet i have the code 110 in column A3 and the amount to fill on the BULK TOTES sheet is 510 so i want 510 to show in the production report sheet under the column 'BULK LVL'

also i want this function to work if there is no code in the 'CODE' column on the production report calc sheet, but if i enter a code it will pick up the information required (Ammount to fill) from the ' BULK TOTES' sheet and input it into the 'BULK LVL' column on the 'Production Report Calc' Sheet.

This in Bulk lvl column?
=IFERROR(INDEX('BULK TOTES'!E$2:E$26,MATCH(A3,'BULK TOTES'!A$2:A$28,)),)