'Look for a value in more than one column and get the corresponding address
How to look for a value(text value) in the entire worksheet and get the row and column number of the cell which contain this value? I plan to use this column number to retrieve a value in this column. We suppose that there is only one instance of the value we are looking for.
It seems like when using Match function we've got to know which column to look for in, but in my case this column is unknown.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|