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