Forum Discussion
Number entered as text in text formatted cell
I have a column where the entire column was selected and the format specified as text. However, when I enter data that looks like a number, e.g. 12345, I get the warning about a number entered as tex...
HelloPReagan ,
Yes, that does enter the number as text, but the apostrophe, "'" is in the cell and makes the VLOOKUP not work. The VLOOKUP needs to be just text as that is what it is in the table which is being searched. But thanks for the suggestion!
Frank
I think the bolded part is what you're interested in. This formula will check for number or text.
=IFERROR(VLOOKUP(TEXT(A2,"0"),table_array,2,0),VLOOKUP(A2*1,table_array,2,0))