I'm not sure about the values(names) thing, but vlookup is feeble under
certain circumstances. Try Index/Match as an alternative:
http://www.contextures.com/xlFunctio...tml#IndexMatch

That link should give you a few ideas and help you overcome the challenge
you face.

Regards,
Ryan--

--
RyGuy


"Manny" wrote:

I'm doing a VLookup function in Worksheet A to find in Worksheet B. The data
in Worksheet B was paste special: values. I did subtotals on the original
data and wanted to see the subtotals without the detail this is why I pasted
special as values. .

Even when I change the format in Worksheet B to match in Worksheet A, it
doesnt work. The data in both worksheets are in Text but the VLookup still
doesnt work.

When I retype the values(names) in the first column of the data range, it
works. This may be fine for a few names but not a couple of hundred.

Does anyone know how to resolve this?