I can't find a way to dynamically define the lookup-array C:C for MATCH formula:
=MATCH(A1,C:C,0)
I need to define the "C:C" range by using the numeric values for the columns (column C is 3).
Already tried converting the number to char and using it in the formula but it doesn't work:
=MATCH(A1,CHAR(3+64),0)
برچسب:
نویسنده: استخدام کار