=SEARCH({0,1,2,3,4,5,6,7,8,9},G2,6)
returns the position of 1st zero found in the string starting from the 6 th
character

=SEARCH({1000,3000},G2,6)
returns an error because 1000 is not to be found in the string

=SEARCH({3000,1000},G2,6)
will return the position of 3000 in the string

If this post helps click Yes
---------------
Jacob Skaria


"nc" wrote:

G2= 040203 De La Conjo MF 3000 Basic Pay

=SEARCH({0,1,2,3,4,5,6,7,8,9},G2,6)

When I use the above formula to search the the following numbers and it
returns a value.


Why I get an error when I change the formula to,

=SEARCH({1000,3000},G2,6)