=vlookup(A1,表1!a$1$:$b$100,2,false)要加$,否出错
=vlookup(a2,sheet2!a:b,2,false) 是对的，不要加"$"
=vlookup(a2,sheet2!a:b,2,false)
