Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find all matches in an array | Excel Discussion (Misc queries) | |||
Code to determine if a cell contains an array function? | Excel Discussion (Misc queries) | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |