Vlook up

[Martha]

I am doing vlookup on 2 spreadsheets. One has names capitalized and the other
does not. I am trying to compare the sheets and see which names appear on
both sheets and those that do not. Does the fact that some names are
capitalized and the others are not make a difference?
My vlookup will not pulls up only 3 names that appear on both sheets but i
have more than that. Please help me. I can email the spreadsheet for further
assistance.

 

[Dave Peterson]

Worksheet formulas like =vlookup() don't care about case.

But they do care about other things.

I'd review the notes for troubleshooting =vlookup() formulas from Debra
Dalgleish:

http://contextures.com/xlFunctions02.html#Trouble

 

[HKaplan]

Vlookup will look up exact matches for capital letters and lower or
proper case.

There may be other characters (like spaces) in one of the cell
entries, which will return no match. Examine 1 or 2 that should match
but don't, and you might find the issue. For example Bob Smith will
look up BOB SMITH. But Bob Smith will not lookup Bob Smith. Spaces
can be leading or trailing in the cell. Check that out.

And make sure you use the false switch (i.e. vlookup(A1,mytable,
2,false).