software

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

Hello from Steved

this will work on Text or Number

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

quot;Stevedquot; wrote:

gt; Hello from Steved
gt;
gt; I get worksheets sent, my question please can the formula below be so that
gt; in Column A it will operate whether it is a number cell or a text cell in
gt; other words an either or. Thankyou.
gt;
gt;
gt; =IF(ISNA(VLOOKUP(A2,'Auckland Kilometre Total''s'!$A$6:$H$1991,2,FALSE))
gt;
gt;
gt;