FIND function exact match

Good morning,

Is there anyway that I can make this formula look for an exact match?

=IFERROR(IF(FIND(D$1,catdata!$C2, 1)>0,D$1)," ")

This formula is repeated across columns D to Q looking for different models (in D1 to Q1) within Column C (which links to my catdata). Please see attached image.

The problem i'm having is that when LF45 is in column C it is being matched to F45 in column D (incorrectly) and LF45 in column N. The same with LF55, this is matched to F55 in Column E (incorrectly) and LF55 in column Q.

excel1.JPG

Thanks
Katie

Apologies, please see attached.

excelmodels.xlsx

Use this in D2 and drag across

=IF(ISNUMBER(FIND(", "&D$1,", "&$C2)),D$1,"")

Fantastic - thank you very much! :D

I've just tested this with some more data and when there is a model CF75IV it separates into both
CF75 and CF75IV. Is there a way to tweak this to get it working for these ones as well? I've attached the spreadsheet.

Thanks
Katie

excelmodels2.xlsx

Thank you for this. I'm not sure where to copy and paste this function? How do I get a module? I'm fairly new to formulas in excel.

Thank you for this. I'm not sure where to copy and paste this function? How do I get a module? I'm fairly new to formulas in excel.

Option Explicit

Function FindMe(strSource As String, strMatch As String) As String

Dim i As Integer
Dim j As Integer
Dim intK As Integer
Dim strModel(5) As String

FindMe = ""
i = 0
j = 1
Do While InStr(j, strSource, ", ", 1) > 0
If i = 0 Then intK = 0 Else intK = Len(strModel(i - 1)) + 2
strModel(i) = Mid(strSource, j, InStr(j, strSource, ", ", 1) - 1 - intK)
j = j + Len(strModel(i)) + 2
i = i + 1
Loop
strModel(i) = Mid(strSource, j, 10)



For j = 0 To i
If strModel(j) = strMatch Then FindMe = strMatch
Next

End Function

Thank you this works well

Originally Posted by martindwilson

=if(isnumber(find(" "&d$1&" "," "&substitute($c2,",","")&" ")),d$1,"")

Thank you for explaining how to do that, it works If for example F45 is not in C2, can the function put in a space rather than just leaving it blank?

Thanks
Katie

Originally Posted by adyteo

1. Open Excel
2. Press Alt + F11
3. Click Insert (in the menu) and click Module
4. In the new module, paste the code from my previous post
5. In case you do not have any restrictions on running macros, then just go to your sheet and type = findme(xx,yy) (see my post above)
6. If you have restrictions for running macros, it is getting a little more complicated. Buy we'll discuss that once you go through steps 1 to 5

I've been testing these formulas on my data this morning and they work perfectly! They are going to save me hours of manual work - thank you so much for all of your help

Pl see attached file.