# Match partial text string in one sheet to another text string in another sheet

Solved/Closed
Related:

- If cell contains partial text then return value in another cell
- Vlookup if cell contains partial text - Best answers
- Excel if cell contains partial text - Best answers
- If cell contains date then return value ✓ - Office Software Forum
- If a cell has text then return value ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum

## 1 response

TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552

Nov 5, 2020 at 11:25 AM

Nov 5, 2020 at 11:25 AM

Hi Santos,

Give the following formula a try:

Best regards,

Trowa

Give the following formula a try:

**=IF(ISERROR(VLOOKUP("*" & A1 & "*",Sheet2!$A$1:$A$4,1,0)),"x",VLOOKUP("*" & A1 & "*",Sheet2!$A$1:$A$4,1,0))**Best regards,

Trowa

Nov 5, 2020 at 12:02 PM

Thank you very much!