Forum Discussion
How to exclude a Value from a lookup & array formula
HI All, how i can add an exclusion of a specific value in the following formula?? "=IFERROR (LOOKUP(1,ARRAYFORMULA(1/(A2:m2 <> "")),A2:m2),"")" this formula takes the last value of the row b...
I believe Arrayformula is a Sheets function. Which app are you working in?
More exactly it appears if convert Sheets file to Excel.
