Related:

- Vlookup if cell contains partial text
- If cell contains partial text - Best answers
- If cell contains partial text then return value in another cell - Best answers
- Match partial text string in one sheet to another text string in another sheet ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum

## 1 response

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

Feb 26, 2010 at 03:17 PM

Feb 26, 2010 at 03:17 PM

You need to use search and find functions

Feb 26, 2010 at 03:22 PM

Feb 26, 2010 at 03:33 PM

https://ccm.net/forum/affich-46323-find-word-within-cell-put-value-in-adjacent#22

Feb 26, 2010 at 03:52 PM

Example: =vlookup(A1, B1:D50, 3, false) would look for an exact match for A1 and return the data from the 3 column. But if A1 doesn't have an exact match, but is contained partially in the contents of a cell or cells in a range, I need it to return "yes." Changing the "true" doesn't work b/c I have too many cells that contain similar data.

Thanks