Index and match funtions problem

[bebe88]

I have a look up table with the user names in column a and
their userid in column B . If the values in column d matches any
userid in column B then return the name of the user. I've started with
the function below and it works fine if the values in column d are
alphebets and numbers. However, when there is a "?" in the user id
then the result is incorrect.

Function ...

INDEX('$A$1:$A$20,MATCH(d9,$B$1:$B$20,FALSE),1)

Please help me.

Thanks,
bebe88

 

[Aladin Akyurek]

Try replacing D9 in MATCH with...

SUBSTITUTE(D9,"?","~?")