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)))