ExcelBanter - Formula to reconize text or number please

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula to reconize text or number please (https://www.excelbanter.com/excel-worksheet-functions/87757-formula-reconize-text-number-please.html)

Steved

Formula to reconize text or number please

Hello from Steved

I get worksheets sent, my question please can the formula below be so that
in Column A it will operate whether it is a number cell or a text cell in
other words an either or. Thankyou.

=IF(ISNA(VLOOKUP(A2,'Auckland Kilometre Total''s'!$A$6:$H$1991,2,FALSE))

Steved

Formula to reconize text or number please

Hello from Steved

this will work on Text or Number

=IF(ISNA(VLOOKUP(--A2,'Auckland Kilometre Total''s'!$A$6:$H$1991,2,FALSE))

"Steved" wrote:

Hello from Steved

I get worksheets sent, my question please can the formula below be so that
in Column A it will operate whether it is a number cell or a text cell in
other words an either or. Thankyou.

=IF(ISNA(VLOOKUP(A2,'Auckland Kilometre Total''s'!$A$6:$H$1991,2,FALSE))

All times are GMT +1. The time now is 01:03 PM.