in sheet bom!b2 =vlookup(a2,"'matereal master'!$a$2:$b$1000,2,false)