excel - Perform MID or LEFT on ARRAY -


match requires array second parameter.

eg. =match(sheet1!a1 ; sheet2!a1:a4 ; 0)

is there way match substrings of array values in lookup using left/mid?

eg. =match(sheet1!a1 ; left(sheet2!a1:a4;5) ; 0)

the above example gives #value! error, understand why not working, want know if there way acheive desired result? matching using substring each value in array?

you can array enter formula make work. that, mean need press ctrl+shift+enter after typing in formula instead of hitting enter.


Comments

Popular posts from this blog

c++11 - Intel compiler and "cannot have an in-class initializer" when using constexpr -

rest - Spring boot: Request method 'PUT' not supported -

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -