2

I've got a problem with the vlookup() function. I search a text in a table (A column) and want to return the E-column value (E10). However, vlookup() returns the last value of the column (E35). I guess I made a mistake but I've really no clue about it. Could you help me ?

Here is the table

Thanks a lot !

Improve this question

1 Answer 1

Reset to default
2

You didn't specify parameter 4 (can be 'TRUE' or 'FALSE'), so the match be exact. Check your search value and the table content for extra blanks before or after the texts (i.e.: -using _ for a blank - _Aaron != Aaron_ != Aaron, etc.)

Improve this answer
3
  • If I put the parameter 4, it returns #N/A. I've double checked the blanks into the value and the table.
    – MarkUs0
    Jul 29, 2016 at 19:06
  • That proves the point - it does not find an exact match. From a screen copy, I can't tell where the texts would be different. Try to put A10 instead C3 in the first param, then there can be no different spelling. Or put =c3=a10 in a free cell and see if they are equal. that is the root of your issue.
    – Aganju
    Jul 29, 2016 at 19:09
  • Yes, you had right. I used the trim() function and it found a blank. Thanks for your support.
    – MarkUs0
    Jul 30, 2016 at 2:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .