Forum Discussion
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...
Sure, how can I reach you? Email?
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
- I 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
Didn't catch what are the numbers are in K28:K400. Birthday could be converted into date as
=LET( myBirthdayStr, Sheet1!$A$5, dateTxt, TRIM(TEXTAFTER(A5, ":")), splitDate, TEXTSPLIT(dateTxt,"/"), DATE(INDEX(splitDate,3),INDEX(splitDate,2),INDEX(splitDate,1)) )what is after that?
- Doesn't work? All I'm trying to do is use the K column array range $K$28:$K$400 as a filter. If $D5 has ANY partial match to ANY cell in the K range, then I simply need $D5 copied over to $E5. And if there is no match, then I want $E5 left blank. Hope that clears things. Thank you for your help.
HansVogelaar Sorry Im new here. I see it can be attached to replies. Please confirm you can download the test excel document that is attached to this reply. Thank you
I can download the workbook, but it heavily depends on US date format, so I cannot do anything with it.
I hope that someone who uses US date format can help you.
