Multiple Arguments Excel

0 votes

If no data is entered into the recording file, I need the formula below to support the argument of N being Refused or Blank as well. I keep making the mistake of having too many reasons, and even the most logical solutions I have tried have failed.

=IF(IFERROR(INDEX(FILTER([Recording.xlsx]Wednesday!$D$2:$D$26,[Recording.xlsx]Wednesday!$B$2:$B$26<>""),ROW()-2),"")="Y","Accepted","")

I am wanting to include the following:

="N","Refused","")

The formula needs to check the file for Y, N or left blank. If Y it will return Accepted, if N will return refused, if no information is entered it will remain blank.

Feb 3, 2023 in Others by Kithuzzz
• 38,010 points
403 views

1 answer to this question.

0 votes

Use the SWITCH function:

=SWITCH(IFERROR(INDEX(FILTER([Recording.xlsx]Wednesday!$D$2:$D$26,[Recording.xlsx]Wednesday!$B$2:$B$26<>""),ROW()-2),""),"Y","Accepted","N","Refused","")

This way, you avoid using an auxiliary cell, and most importantly, avoid repeating the whole call to IFERROR(INDEX(FILTER())).

Indented view for better understanding:

=SWITCH
 (
    IFERROR
    (
        INDEX
        (
            FILTER([Recording.xlsx]Wednesday!$D$2:$D$26,[Recording.xlsx]Wednesday!$B$2:$B$26<>""),
            ROW()-2
        ),
        ""
    ),
    "Y","Accepted",
    "N","Refused",
    ""
 )
answered Feb 3, 2023 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

Create unique rows in Excel with limited data to be used in multiple columns

This setup isn't readily generalizable, though since ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 63,700 points
582 views
0 votes
1 answer

Is there any way in python to auto-correct spelling mistake in multiple rows of an excel files of a single column?

Use Spellchecker for doing your stuff: import pandas ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 63,700 points
1,708 views
0 votes
1 answer

Excel VBA - downloading multiple historical exchange rates

Do columns C and D contain your ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 63,700 points
478 views
0 votes
1 answer

Pentaho excel input from multiple sheets to textfile

It's possible to use numerous Excel inputs ...READ MORE

answered Oct 20, 2022 in Others by narikkadan
• 63,700 points
1,255 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
980 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,090 points
900 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,090 points
4,176 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
3,969 views
0 votes
1 answer

Download multiple excel files linked through urls in R

Try something along the lines of: for (i ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,700 points
1,129 views
0 votes
1 answer

SharePoint - Excel Online - Edit in Excel and Edit in Browser multiple users

Here is the Microsoft article regarding co-authoring https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=en-US&rs=en-US&ad=US When ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,700 points
1,034 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