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
• 38,010 points
642 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
• 63,420 points

Related Questions In Others

0 votes
1 answer

Can an Excel xll function indicate that the return value should be displayed as a date and not a number?

To my knowledge, the only method to ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,420 points
492 views
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, 2023 in Others by narikkadan
• 63,420 points
384 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, 2023 in Others by narikkadan
• 63,420 points
281 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,670 points
1,236 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,670 points
1,422 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,670 points
697 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
• 23,260 points
2,329 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, 2023 in Others by narikkadan
• 63,420 points
340 views
0 votes
1 answer

Excel worksheet multi-criteria function (like Index-Match array) to fetch last value of an item, looking up by item name and date

Use: =SUMIFS(C:C,B:B,E12,A:A,MAXIFS(A:A,B:B,E12)) It will return the value at the ...READ MORE

answered Apr 6, 2023 in Others by narikkadan
• 63,420 points
413 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