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?