VLOOKUP with part of the text in a database
Solved
senecartour
Posted messages
391
Status
Membre
-
Amiral -
Amiral -
Hello,
I would like to perform a VLOOKUP with the data from column A of this sheet in the data from the base sheet and retrieve the value contained in the cell.
In other words, if I find the word in my base, I want to retrieve the value of the entire cell where the word is located.
Attached, you have the file containing the data
-sheet "base" == >My search database
-sheet "rech" ==> the text to search for and an example of the expected result.
https://www.cjoint.com/c/EHevt7ImXkG
Thank you in advance for your help!!
Configuration: Windows 7 / Internet Explorer 8.0
--
Sharing knowledge is the best way to learn!
I would like to perform a VLOOKUP with the data from column A of this sheet in the data from the base sheet and retrieve the value contained in the cell.
In other words, if I find the word in my base, I want to retrieve the value of the entire cell where the word is located.
Attached, you have the file containing the data
-sheet "base" == >My search database
-sheet "rech" ==> the text to search for and an example of the expected result.
https://www.cjoint.com/c/EHevt7ImXkG
Thank you in advance for your help!!
Configuration: Windows 7 / Internet Explorer 8.0
--
Sharing knowledge is the best way to learn!
Great, thank you very much it works.
Have a nice day.