|VLOOKUP (or any of the LOOKUP function, for that matter) will only find the first occurrence of a value in a list. |
Depending on what you are trying to do, there are workarounds for finding multiple occurrences. A few different methods can be found there:
Google around for more.
Posting Tip: Before posting Data or VBA Code, read this How-To.