Are you using FALSE as the last argument of VLOOKUP? That would ensure
that only an exact match is found. For example

=VLOOKUP("Sam",A1:C100,3,FALSE)

Assuming your data was in A1:C100.


HTH,
JP

On Mar 10, 11:09*pm, Jennifer Cali
wrote:
Sorry, the example was the problem I'm having. Sally has a different number
than Sam who has a different number than Tara.
--
Thank you! - Jennifer



"JP" wrote:
Just based on your sample, the phone numbers are all the same, so that
might explain why a VLOOKUP on Sam and Sally would appear to return
only Sam's phone number.

HTH,
JP