Back to Blog
If MATCH does not find a value from List A within List B, it’ll return #N/A and ISNA will display TRUE. Whenever MATCH returns the relative position and not #N/A, ISNA simply spits out FALSE. If MATCH finds a value from List A within List B, it’ll return the relative position of the value in List B. In our example we are using MATCH to tell ISNA whether to display TRUE or FALSE. MATCH is the second function, which returns the relative position of an item in an array (in our example, either List A or List B) that matches a specified value in a specified order. If a value is #N/A in an ISNA formula, it’ll display TRUE. ISNA is the first function in our formula, which does only one thing in life: checks whether a value is #N/A (which is the error value Excel uses to say “no value is available”). You could take it one step farther by filtering either list to display only TRUE which would then only show the values missing from either list. TRUE = value is missing from the other listįALSE = value is not missing from the other list If any value from List A is found in List B, FALSE will appear next to that value in List A’s “Missing?” column. If any value from List A is missing from List B, a red TRUE will appear next to that value in List A’s “Missing?” column. Repeat steps four through six for cell E5, making sure to copy the formula down the entire List B.In cell E5, enter the formula: =ISNA(MATCH(D5,A:A,0)) and press Enter. ![]()
0 Comments
Read More
Leave a Reply. |