arraysexcelexcel-formulacross-reference
Excel Array Functionality for Cross Check
I have 2 columns in my Excel File. First column is called Planned Q and has values separated by Comma. The second column is called Current Q and it has only one value.
As per below screen, I want to check if any of A2 value is in B2 value it should find/call a MATCH otherwise it is Mis-Match. How can I perform this task?
Thank you for your help!
Solution
Use SEARCH:
=IF(ISNUMBER(SEARCH(B2,A2)),"Match","Mis-Match")
- Filter or map nodelists in ES6
- What is the most efficient way of getting an empty array in C# in terms of time and space?
- How do I find the closest possible sum of an Array's elements to a particular value?
- Exporting an array in bash script
- Cloning an array in Javascript/Typescript
- Remove array from JSON when it appears
- Find repeated elements occuring more than Once
- why can init array in struct with array-name in C
- How to determine if one array contains all elements of another array
- Why does my nodelist contain 0 items when console logged from my JS file?
- Reading dynamic sized byte arrays as integers
- Deep Copy with Array
- Restructure a 2d array to segment row values into associatively keyed subarrays within the row
- Insertion Sort from Right to left with Javascript
- formatting an array using php
- Getting the most frequent value of an array
- php transform array into multidim array
- Date change function in PHP
- C++ replacement for C99 VLAs (goal: preserve performance)
- Azure Logic App - For Each Key/Value Pair (Answered!)
- Difference between array_push() and $array[] =
- For loop skipping final iteration
- How to create a numpy array from a pydub AudioSegment?
- Find the 2nd highest no from array, where array contains duplicate values
- Group 2d array data by a column and apply default values where a date key is missing
- Convert a 2d array into a flat associative array using two columns
- Print 2d array data on separate lines with all row values indented except for the first value in each row
- Simplify a multidimensional array of filtering conditions using recursion
- Return result set from PDO query as an associative array from two columns
- Remove empty elements from a 2d array while inside of nested foreach loops