We would like to know how to work with the value of a cell instead of its formatted value. For example, we have a vlookup problem that even though both the data to look for and the data in the array looks the same, both have different format. The data in the array is in text format and the data in the lookup is numeric. With EE we are have a solution for this situation, but the problem provoked this question.
Thus, this problem can happen in vLookup, like any other function. Hence, how can we work with the exact value within the cell disregarding its format? This way the functions being used can work appropriate to its purpose and design.