Forum Discussion
Solved
LOOKUP Expression?
Hello, I have two sheets in an Excel document, Data 1 and Data 2. Data 1 has Columns [Participant] and [Area]. Data 2 has the same columns but the [Area] is empty. I would like to know ho...
Sergei,
Can you explain the double-dash used in the MATCH function? (--$C2)
Can you explain the double-dash used in the MATCH function? (--$C2)
Kim, there are numbers as text in column C, and in lookup column we have numbers. Double dash converts texts to numbers. Same as VALUE() here.
I am not finding it necessary to use double dash to convert "FALSE" to 0 in Excel Office 365. I can just act as if FALSE is a 0 or TRUE is a 1 and use it in other formulas.
Cell A2 resolves to FALSE
CELL A3 contains =A2*3 and displays 0
Same behavior with TRUE. Double dash seems no longer necessary.
Kim_Wennerberg , that's not about TRUE and FALSE, that's about MATCH
=MATCH("2",{1,2,3},0) returns #N/A =MATCH(--"2",{1,2,3},0) returns 2