Matching - V Lookups
I'm Matching two files based on last name. I've made sure the last names in
each file are properly formatted (proper function - first letter capped) and the last names in each file are sorted ascending and located in column A. When I look at the two files I see obvious matches just by glancing through it, but the V lookups are showing none. I've done hundreds of these things............could someone please tell me whats wrong thanks |
Matching - V Lookups
Look for blank characters padded at the end of the name... "Smith" and "Smith
" are not the same thing and a Vlookup will return nothing... -- HTH... Jim Thomlinson " wrote: I'm Matching two files based on last name. I've made sure the last names in each file are properly formatted (proper function - first letter capped) and the last names in each file are sorted ascending and located in column A. When I look at the two files I see obvious matches just by glancing through it, but the V lookups are showing none. I've done hundreds of these things............could someone please tell me whats wrong thanks |
All times are GMT +1. The time now is 03:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com