Formula search keywords in multiple columns

Closed
Report
Posts
7
Registration date
Tuesday April 28, 2009
Status
Member
Last seen
September 22, 2017
-
 Blocked Profile -
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

1 reply


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