Forum Discussion
Cmoreno89
Aug 13, 2023Brass Contributor
Formula for .. IF Partial Match = PASTE, IF NO MATCH = BLANK
Hello everyone, I'm looking for a partial match formula. I'm looking to partial match cell $D5 in my excel spreadsheet with $K$28:$K$400. $D5 must be a PARTIAL MATCH to ANY of the cells i...
Cmoreno89
Aug 13, 2023Brass Contributor
Didn't work. 😞
HansVogelaar
Aug 13, 2023MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Cmoreno89Aug 13, 2023Brass ContributorSure, how can I reach you? Email?
- HansVogelaarAug 13, 2023MVP
Cmoreno89 If you cannot upload the workbook to OneDrive, Google Drive or Dropbox, then obtain a link to the uploaded file and paste that into a reply, you can send the sample workbook to
hans dot vogelaar at gmail dot com
- Cmoreno89Aug 13, 2023Brass ContributorI didn't include any spaces " " or "/" in the test excel document's K column, perhaps you can add them to the K column to see if it will still work with a new formula