vlookup mismatch between text and no

[xljgd]

I have a table with columns looking at another table.

column h
444 -Task Error
210
210
electrical210
This looks at my table which the values

210
220
230
240
250
260
270


This formula looks at column H and takes out the first 3 letters and compares his value I another table.

if match is not found it gives me "task error"

It works out fine when working with numbers but I do have some text in the table. say

electrical210 which I want he user to see as an Task error and correct it.

here it is comparing value ele to my tables and not returning any error.

how do I say if text use one formula if number use the following formula.

=IF(ISNA(VLOOKUP((LEFT(H5,3))+0,tasklog!$B$9:$B$15,1,FALSE)),"TASK ERROR","")

Any help will be greatly appreciated.

 

[bosco_yip]

Maybe,

=IF(OR(ISERR(0+LEFT(H5,3)),ISNA(VLOOKUP(0+LEFT(H5,3),tasklog!$B$9:$B$15,1,FALSE))),"TASK ERROR","")

Regards
Bosco

 

[xljgd]

Works like a charm.
Thanks for your input and your time.