I'm having trouble with vlookup two values. I need help to fix a logic check formula to compare two values, but pull one as text *1 to take formatting into account.
I'm attempting '=IF(INDEX(TEXT(A16,"0"))*1)=(INDEX(C16)),"CORRECT","FAIL" but a VLOOKUP might work as effectively
Relates to a significant excel bug - see sheet
Solved by V. Y. in 30 mins