=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0)) 这个公式说我少了边括号.

=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0)) 这个公式说我少了边括号.

=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0),VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0))

=IF(ISNA(VLOOKUP(W4,[Book2]Sheet1!$A$2:$B$153,2,0))

明显的左边有三个括号IF(ISNA(VLOOKUP(
右边只有两个括号，所以，IF还少个反括号