Hi All
I am trying to add a MID function to a MATCH Formula as the urls I need to check are over 255 characters.
I have tried to do this as a XMATCH formula but it would not return the row numbers and would crash my system.
The following formula works but not with anything over 255 characters, so I would like to add a MID function so it just checks the middle 255 Characters but I can not get it to work.
This is the formula at the moment - =IF(ISNA(MATCH(A2,Hosted!B:B,0)),"",MATCH(A2,Hosted!B:B,0))
Can anyone tell me how and where to add the MID fundtion please?
I have have attached a sample document with the formula working and with an example of it breaking.
This is the results tab where urls are added, those with less than 255 characters are pulling the rom number from the "Hosted" sheet correctly (Higlighted in green). Also those that have more than 255 characters return #Value! (Highlighted in Yellow)
Example 1.JPG
This is the Sheets with the list of URL's
Example 2.JPG
Any help on this would be massively appreciated as it is driving me crazy and I have been working on this one formula for days!!
Bookmarks