Excel : VLOOKUP returns the last value in the column

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 ?

Excel : VLOOKUP returns the last value in the column

Thanks a lot !

Replay

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.)

Category: microsoft excel Time: 2016-07-29 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.124 (s). 12 q(s)