回复：QuickBooks is opened.

来源: 于 2011-09-16 12:38:52 [博客] [旧帖] [给我悄悄话] 本文已被阅读：次

Tools > options > calculation tab > check 'automatic'

Also if you want an exact match you should include a false statement at the end

e.g vlookup(Cell,array,col,false)