IF(ISNA(MATCH(E4,$B$4:$B$10,0)),”Does Not Exist”,”Exists”)becomesĪfter that, we are getting Exists for the products Banana and Lemon which are available in the Product List range, and for the unavailable products we are getting Does not Exist.MATCH(E4,$B$4:$B$10,0) finds the exact match of the product Green Apple in the range $B$4:$B$10 and gives the row index number of this product in the range $B$4:$B$10 and for not finding the value in the range returns #N/A.In this section, we will use the combination of the IF function, ISNA function, MATCH function to determine the availability status of the products in the range Product List. Method-6: Using IF, ISNA, and MATCH Functions to Check If Value Exists in Range ➤ Press ENTER and drag down the Fill Handle tool.Įventually, we are getting Exists for the products Banana and Lemon which are available in the Product List range, and for the unavailable products we are getting Does not Exist.

IF(TRUE, “Does Not Exist”, “Exists”) → returns Does Not Exist for TRUE and Exists for FALSE ISNA(#N/A) → returns TRUE if there is a #N/A error otherwise FALSE VLOOKUP(E4,$B$4:$B$10,1, FALSE) → finds the exact match of the product Green Apple in the range $B$4:$B$10 and extracts this value from this column and for not finding the value in the range returns #N/A.

How to find a range in excel