i want to find a value in a refference array

H

Hasty

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!
 
B

Biff

Hi!

Try this:

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

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to correct a #N/A in vlookup 1
Drop down list control value in vba 2
Calculate the median value before a specified list 0
How can I do a lookup to a specific cell on another tab 1
Dynamic pointing to a cell 0
Array assignment 1
Date lists 3
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2

Top