Formula to reconize text or number please

S

Steved

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))
 
S

Steved

Hello from Steved

this will work on Text or Number

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