a reference to excel in

My sheet1 in a month of production as the product name in sheet2 b as product specifications in a, b as the product name and specifications of all reference to what to do when the input product name corresponds to b out in the corresponding product specifications

cell in sheet1 of B2 enter the following formula, the drop-down fill = if (a2 =””,””, vlookup (a2, sheet2! a:b, 2,0))

= vlookup (a2, sheet2! a:b, 2,0)

If only requires the product specifications can be used upstairs that if the formula is to enter the product name in column b corresponds to a time when alternative specifications are available, then use offset + validity set

agree on the first floor of the answers, in order to prevent the error column B2 value, you can try if (ISERROR (vlookup (a2, sheet2! a:b, 2,0 )),””, vlookup ( a2, sheet2! a:b, 2,0))