none
Index Match using wildcard RRS feed

  • Question

  • Hi Team,

    Hope you are well. I need some assistance please. I have got the below Index Match Formula which works fine as:

    =INDEX($H$1:$H$150;MATCH(1;($D$1:$D$150=L3)*($G$1:$G$150=M3);0))

    But when I include the wildcard search " &"*", it does not work at all:

    =INDEX($H$1:$H$150;MATCH(1;($D$1:$D$150=L3&"*")*($G$1:$G$150=M3);0))

    I have been going around in circles and dont know where I am going wrong.

    Please can someone kindly help me? It probably is just a little thing I am missing.

    Thanks, Chaz

    Wednesday, November 5, 2014 12:32 PM

Answers