How do I get excel to specify the range of cells that has a certain value/text? I have 5000 texts in a column with various airport names. I have grouped them in alphabetical order and now I would like to find out from which cell to which cell does the airport LAX appears in for example.

CodePudding user response：

VLookup() to the rescue as you can see from the following screenshot:

The explanation of the used parameters is exactly the same as in