seeker2003
New Member
- Joined
- Jan 21, 2005
- Messages
- 1
Is there an excel function to scan a cell for a particular value?
e.g. Cell contains string "abcd", function will display "1" if "d" is in that string.
I know vlookup works, but you can only search on the 1st column and would like the flexibility to search other columns.
TIA.
e.g. Cell contains string "abcd", function will display "1" if "d" is in that string.
I know vlookup works, but you can only search on the 1st column and would like the flexibility to search other columns.
TIA.