表一名字为D4,求数字的单元格为U4,表二D21为名字,G21为数字,在表一U4上输入公式=IF(ISERROR(VLLOKUP(D4,[Book1]Sheet1!$D$21:$G$60,2,0),"",VLLOKUP(D4,[Book1]Sheet1!$D$21:$G$60,2,0)).显示为公式错误,请帮忙