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, 2022 in Others by Kithuzzz
• 27,940 points
78 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, 2022 by narikkadan
• 51,600 points

Related Questions In Others

0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9 in Others by narikkadan
• 51,600 points
33 views
0 votes
1 answer

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

answered Jan 22 in Others by narikkadan
• 51,600 points
38 views
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, 2022 in Others by gaurav
• 22,940 points
305 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, 2022 in Others by Edureka
• 13,640 points
206 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, 2022 in Others by Edureka
• 13,640 points
374 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, 2022 in Others by Edureka
• 13,640 points
168 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
150 views
0 votes
1 answer

Excel SUM function is not working (shows 0), but using Addition (+) works

The values in A1 and A2 are ...READ MORE

answered Jan 5 in Others by narikkadan
• 51,600 points
48 views
0 votes
1 answer
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