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