To post as a guest, your comment is unpublished.· 5 months agoYou will need to use $ for the lookup cells valuesSo if you have a column of values you want to look up you would modify the formula as follows:=VLOOKUP(E2,$A$2:$C$8,3, TRUE)E2 would change as you fill down but the table you are looking up from will remain constant
1.選擇一個空白單元格，輸入公式 = VLOOKUP（E2，A2：C8,3，TRUE） 進入編輯欄，然後按 Enter 鍵。 看截圖：
- 如何在Excel中vlookup值並返回true或false / yes或no？
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 7 months agoThe value works on the first cell. How do you do it for the entire column cell?
To post as a guest, your comment is unpublished.· 1 years agoawesome, thanks!
To post as a guest, your comment is unpublished.· 2 years agoDoesn't work. if only it was that simple, wouldn't need to be googling for this
To post as a guest, your comment is unpublished.· 1 years agoIt obviously does. Instead of whining and trying to be a smartass about it, you could have at least tried it out.
To post as a guest, your comment is unpublished.· 1 years agoIt does. Try it out before rudely complaining, simple as that.