Adding a Mid Function to a Match Formula

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!!

Originally Posted by markexcelhell

I have tried to attached the sample excel but for some reason it wont allow me to so here are some screen shots.

The paper clip icon does not work for attachments. To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
3. Click the Choose File button to select a file to attached.
4. Click the Upload button to upload the file.
5. Then click the Close This Window button. Your file is now attached to your post.

Cross-posted:

https://stackoverflow.com/questions/...-match-formula

Regards

Originally Posted by markexcelhell

Is there any issue with posting to two different locations? I will happily take one down if it s problem?

You are allowed to post the same question to two locations, but we have a rule that if you do that you must include a link to the other location. The reason we ask this is that otherwise you will have people in both locations duplicating effort. It's even worse if it gets solved in one place, but people are still working on it in the other place.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.