Formula search keywords in multiple columns

Closed
simbaloo Posts 7 Registration date Tuesday April 28, 2009 Status Member Last seen September 22, 2017 - Updated on Oct 9, 2017 at 06:01 AM
 Blocked Profile - Sep 22, 2017 at 07:24 PM
Hello,
I need to find a excel formula (column A) to track keywords in a table with multiple columns.



the key words are for example
Accor
Fairmont
Raffles
Sofitel
Rixos
Mc Gallery
Gallery
Pullman
swissotel
adagio
mercure
sebel
novotel
mama shelter
ibis
formule1`
hotelf1
thalassa

can you please help
thanks in advance
Astrid
Related:

1 response

Blocked Profile
Sep 22, 2017 at 07:24 PM
The picture that you posted, is not posting very well.

Have you looked at Vlookup?
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1?ui=en-us&rs=en-us&ad=us

I am certain it is what you are looking for!
0