vlookup returning the wrong data

Hi

I am working on a form to pull employee identifiers such as employee ID, store number as well as sales performance. I am using the below formula but the data that is being returned is not the correct data for the specific employee. C5 is the employee name (last name, first name) in a single cell. A sample of the spreadsheet I am trying to pull data from is attached. Some employees the formula pulls the right data and some it does not... any ideas??

=IF(C5="","",VLOOKUP(C5,'Raw Data'!A3:N15,2))

...The sample has barely anything to do with the described problem?

Anyway my first-pass guess is that you're running into problems because it's finding an approximate match instead of an exact match.

Try this:

Please Login or Register  to view this content.

IF that doesn't work, then... I dunno, I'd need more information? Like a better example.

I didn't realize but I left off "0" on my formula... it's always the little things that trip you up

Thanks for the response....