Hello everyone,
I have a question in regards to vlookup. I'm extracting data from a directory of employees using their last names with vlookup, and obviously there are many employees with the same last name which can cause error in the data.
How can I resolve this? This has become really trouble some for me and even if there's a way to have vlookup return no data for duplicates while giving data for the unique last names it would be a great help.
Many thanks.
Bookmarks