IF function help needed please

Originally Posted by TMS

Does the URN always have the same number of characters in each of the sections (between the slashes)?

If so, you could set up a list and use MID to extract the code and use that in a VLOOKUP.

Or, if the codes have unique numbers between 1 and 80, you could get away with MATCH

Regards, TMS

Hi TMS,

Yep the URN is always the same format ie xxx/xxxx/xxx/xxxx/xxx

Excuse my ignorance but not familiar with MID, though I have heard of VLOOKUP.

The codes are not numerical, always three alpha characters.

Cheers, Ballst