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