I'm using the below VBA code:
Dim c, DataRow With Data Set c = .Range("A5:A350").Find(KPI, LookIn:=xlValues) If Not c Is Nothing Then DataRow = c.Row End If End With
Now, my problem is that If KPI is for example = "Favourite Hotel" and if i have data that looks like :
Favourite Hotel - London
Favourite Hotel - Cardiff
Favourite Hotel - Birmingham
Then it seems to not look be looking for an exact match (e.g. Favourite Hotel) and rather is finding the first item in the list that contains the KPI string (E.g. Favourite Hotel - London).
How do i make it search for an exact match?