Thread: SEARCH Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nc nc is offline
external usenet poster
 
Posts: 119
Default SEARCH Function

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)