I wonder if there is a way to have the index & match in lookup multi criteria to return blank if the criteria does not match. as the example below.
{=INDEX($A$2:$A$7,MATCH(1,(A10=$B$2:$B$7)*(B10=$C$2:$C$7),0))}
Thanks,
I wonder if there is a way to have the index & match in lookup multi criteria to return blank if the criteria does not match. as the example below.
{=INDEX($A$2:$A$7,MATCH(1,(A10=$B$2:$B$7)*(B10=$C$2:$C$7),0))}
Thanks,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks