Formula to reconize text or number please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The formula works if I copy from Auckland Kilometres 4
Text or Number 2
Nil in Place Off #N/A 2
Text Wrap 5
Searching the formula (not the value) for a text string 1
Adding formulas 4
Works if I copy F Col to A Col 6
Show's #N/A please to showblank. 2

Back
Top