Hi Guys,
I'm using the IF(ISNUMBER(SEARCH formula set to find a especific number in a excel file
=IF(ISNUMBER(SEARCH(E3,$D$2:$D$48)), E3, "NO")
Basicaly I have an array of numbers in E and a combination of words and numbers in D I need to know if the number in E is anywhere in D
For some reason the formula works with just one ROW but not the combination of 48 ROWS
Can someone help?
Thanks a lot!
I'm using the IF(ISNUMBER(SEARCH formula set to find a especific number in a excel file
=IF(ISNUMBER(SEARCH(E3,$D$2:$D$48)), E3, "NO")
Basicaly I have an array of numbers in E and a combination of words and numbers in D I need to know if the number in E is anywhere in D
For some reason the formula works with just one ROW but not the combination of 48 ROWS
Can someone help?
Thanks a lot!