• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLookup Help

N

nsantos

New Member
Hi everyone, I'm having some trouble with this VLookup. Can someone give me a hand with what I'm doing wrong?

Thanks!
 

Attachments

  • VLOOK.xlsx
    70.2 KB · Views: 8
I did that initially but I'm still getting values in some cells in column I when I should be getting "#N/A"

:(
 
Nebu forgot to put a False as the last criteria--a typo I'm sure.
The formula should look like this: =VLOOKUP(B2,$K$2:$L$132,2,FALSE)
 
You must log in or register to reply here.
Back
Top