Get instant live expert help on How do I check if array contains value

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

i want to check if a value exists in a table array ,based on combination of selection in a different table. how do i do this?
Solved by V. J. in 12 mins
I need to check multiple cells in an array for a cell value and return value from row containing match ( cell from First column in that row)
Solved by E. H. in 24 mins
I am trying to figure out a formula to return a cell address within an array that contains a portion of look up value.
Solved by B. J. in 29 mins
I need to find if an array c10 thru g10 contains a number, then return either a X or leave it blank
Solved by C. W. in 15 mins
I'm trying to check and see if the value in cell K is "Monthly" and that cell J contains a date within 7 days. Below if my formula that is giving errors =AND(IF($K$34 = "Monthly"),AND($J$34>TODAY(),$J$34<=(TODAY()+7)))
Solved by I. U. in 28 mins