Excel MATCH function is not working on an array but works once directed to the matched value

0 votes
Using the ISNUMBER and MATCH functions, I am checking to see if a value is present on one of my sheets. Some people's responses to the first test were FALSE. Therefore, I manually reviewed the source data to see if this genuinely did not exist; fortunately, it did. I thus double-checked and ran a test using the ISNUMBER and MATCH functions, but this time, I simply directed the results to the specific cell containing the matched value. This time, the result was TRUE!

Why can Excel find a match on an array but not when pointed to the precise cell, I want to know. How can I solve it, then?
Nov 17 in Others by Kithuzzz
• 20,660 points
27 views

1 answer to this question.

0 votes

According to the definition here: support.microsoft.com/en-us/office/… if you do not define the match type, the lookup array must be in ascending order. 

answered Nov 17 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
0 answers

why is react native video not working on android, but working on ios?

installed react video v. 5.2.0 but an error ...READ MORE

Sep 23 in Others by gaurav
• 22,040 points
178 views
0 votes
1 answer

Excel create an Index on the first sheet with links to subsequent sheets

This seems to be a potential duplicate ...READ MORE

answered Oct 22 in Others by narikkadan
• 37,660 points
50 views
0 votes
1 answer

MAX function in Excel: is it possible to provide the range by means of variables?

Try this: =MAX(INDEX(A:A,B2):INDEX(A:A,B3)) READ MORE

answered Nov 15 in Others by narikkadan
• 37,660 points
25 views
0 votes
1 answer

How to increment row value in an index function in excel?

Try this- =INDEX($F$27:$F$40,COLUMN(A$1)) It will automatically increase the row ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
34 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
142 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
240 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
71 views
0 votes
1 answer
0 votes
1 answer

Is there a way to lock cells after editing an excel sheet that's on sharepoint?

The Excel Web version (which, based on ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
85 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP