"Text and the value found is of type Number, the #N/A Error is returned.The searched portion of Searched shall be sorted in ascending order, and so that values of type Number precede values of type Text if both types are included (e.g., -2, 0, 2, ???A???, ???B???).There are two major uses for this function; the 3-parameter version (vector) and the 2-parameter version (non-vector array).Note: Intero" . . . .