I'd follow Tyro's suggestion and post some real sample data, along
with the formula you are actually using.

Regarding the "Calculate" message, it's difficult to debug what's
going on because we have no way to tell what your worksheet
environment looks like. If you have too many formulas (esp array
formulas), other design elements, fonts, etc that message can remain
permanently.

Check out this KB:

http://support.microsoft.com/kb/243495


HTH,
JP

On Mar 10, 11:22*pm, Jennifer Cali
wrote:
Yep, I'm definitely including the FALSE.

The other *odd* thing I see is even AFTER the cells caluculate, the workbook
continues to say "CALCULATE" in the bottom left corner. Thoughts?

--
Thank you! - Jennifer



"JP" wrote:
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- Hide quoted text -

- Show quoted text -