• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup text string

madocar

madocar

Member
Hello,

is there some opportunity of using VLOOKUP function with text string. I want to lookup a text string

Thanks
 
Hi, madocar!
VLOOKUP function works with any data type, numbers (integer or decimal), texts, booleans (true/false).
Regards!
 
Unless you are asking about looking up something inside a text string. Use FIND or SEARCH for that.
 
I forgot to use trim function. There was a space
Anyway, may I use vlookup function if the searched value is not in first column? It seems it does not work
Thanks
 
Hi ,

You can use VLOOKUP only if the looked-for value ( the first parameter in the VLOOKUP function ) is present in the first column of the lookup range ( the second parameter in the VLOOKUP function ) ; if this is not the case , use the INDEX / MATCH combination.

Narayan
 
You must log in or register to reply here.
Back
Top