Index and match funtions problem

  • Thread starter Thread starter bebe88
  • Start date Start date
B

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

:confused:
 
Back
Top