Convert roman number to number in Excel and Google Sheets
=MATCH(A2,INDEX(ROMAN(ROW(INDIRECT("1:4000"))),0),0)
=MATCH(A2,INDEX(ROMAN(ROW(INDIRECT("1:4000"))),0),0)
=MATCH(A2,INDEX(ROMAN(ROW(INDIRECT("1:4000"))),0),0)
A2 = data cell
=MATCH(A2,INDEX(ROMAN(ROW(INDIRECT("1:4000"))),0),0)
A2 = data cell