sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
Really struggling with this one, must be a simple solution....
I need to search a column for an exact match to a whole number - each row contains a mixture of letters and numbers. Once found I just need to store the row number.
Note, with this though I need to be sure it does find precise matches, so if I searched for "2213" I would not want it to return a find for "22131".
The search range is sheet4 column A, (from A2 to the last used row), the value to search will change and I haven't decided how the user will carry out the search yet so for this purpose lets assume the search number will be "2213".
Can anyone help me please?
I need to search a column for an exact match to a whole number - each row contains a mixture of letters and numbers. Once found I just need to store the row number.
Note, with this though I need to be sure it does find precise matches, so if I searched for "2213" I would not want it to return a find for "22131".
The search range is sheet4 column A, (from A2 to the last used row), the value to search will change and I haven't decided how the user will carry out the search yet so for this purpose lets assume the search number will be "2213".
Can anyone help me please?