Avoiding index match N A value

0 votes

When a value and combined name in column L match, I index column O.

A #N/A value will be returned if the combined name cannot be found in the table I am indexing or matching. How can I prevent this? I looked at the ISNA function, but all it returns is True or False. I could use this to create a different formula to configure it, but I'm looking for a simpler, faster method.

The current index/match being used is:

=INDEX(O:O,MATCH(ADIST& " " &APROD,L:L,0))

And if I am being passed back a #N/A value I'd like it to say "No Value".

Nov 14 in Others by Kithuzzz
• 20,660 points
28 views

1 answer to this question.

0 votes

Use IFERROR to set an alternative value if the formula you are using returns an error:

=IFERROR(INDEX(O:O,MATCH(ADIST& " " &APROD,L:L,0)),"No Value")
answered Nov 14 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

What is a name function in JavaScript & how to define it?

A named function declares a name as ...READ MORE

answered Mar 7, 2019 in Others by Frankie
• 9,830 points
1,713 views
0 votes
1 answer

How to retrieve the value of a text field in Flutter App?

Hi@akhtar, In your TextField, you can call one ...READ MORE

answered Sep 3, 2020 in Others by MD
• 95,380 points
1,018 views
0 votes
1 answer

Column count doesn't match value count at row 1

The ERROR you are receiving implies that ...READ MORE

answered Feb 11 in Others by Rahul
• 9,680 points
1,300 views
0 votes
1 answer

Get selected value of a dropdown's item using jQuery

To answer your question, start with using ...READ MORE

answered Feb 18 in Others by Aditya
• 7,660 points
2,891 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

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

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

Excel - Make a graph that shows number of occurrences of each value in a column

There is probably a better way to ...READ MORE

answered Oct 21 in Others by narikkadan
• 37,660 points
73 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