i want to find a value in a refference array
 

Hello! I have a small problem. I want to search a value in an array and
return the value true or false. I tryed with "if", "and", "not", but a
strange thing happends: when I press the function button to see if my formula
is wrong, it seems that the formula is corect, but when i insert the formula,
it says: #N/A, #VALUE!. the formula is
IF(A3<Array1,IF(A3<Array2,IF(A3<Array3,"VALUE1, VALUE2)),VALUE3). A3 is the
refference; Array1,2,3 are the arrays where i want to find the value; and
Value1,2,3 are the results. Can anyone please help me!

i want to find a value in a refference array
 

Hi!

Try this:

=IF(A3="","",IF(COUNTIF(Array1,A3),Value1,IF(COUNT IF(Array2,A3),Value2,IF(COUNTIF(Array3,A3),Value3, ""))))

Biff

"Hasty" wrote in message
...
Hello! I have a small problem. I want to search a value in an array and
return the value true or false. I tryed with "if", "and", "not", but a
strange thing happends: when I press the function button to see if my
formula
is wrong, it seems that the formula is corect, but when i insert the
formula,
it says: #N/A, #VALUE!. the formula is
IF(A3<Array1,IF(A3<Array2,IF(A3<Array3,"VALUE1, VALUE2)),VALUE3). A3 is
the
refference; Array1,2,3 are the arrays where i want to find the value; and
Value1,2,3 are the results. Can anyone please help me!