Taking an Index Match Function one step further!

[Ben Morton]

Hi all,

I'm matching ISO country codes to country names.

This works great as long as the 'lookup_value' portion of the match fuction matches the 3 digit code on Sheet3.

Is it possible to return my desired result without this matching perfectly.

So a value in 'Sheet1 Column A' that begins A344xxxxxxx will return the same result in 'Sheet1 Column F' as if 'Column A' just had a 3 digit number.

Pls see the example file for clarification.

Maybe this will required VBA?

If so, sorry for posting in the wrong forum.


Cheers


Ben

[DonkeyOte]

Perhaps you want to utilise MID, eg:

F3: =INDEX(Sheet3!A:A,MATCH(0+MID(Sheet1!A3,2,3),Sheet3!B:B,0))

[Ben Morton]

Thankyou vmuch,

I'd never heard of th 'Mid' fucntion.

Many Thanks