Vlookup with multiple IF statements

[SemperFi]

Hello
I am working on an Excel knowledge base where I have a formula (=IF(ROW(A1)>$B$2; ""; INDEX(Articles!$A:$A; MATCH(ROW(A1); Articles!$B:$B; 0))) ) that is working perfectly to pull a "list" of articles from the article sheet. The problem I'm running into is setting up a Vlookup with multiple IF statements. Let me explain:
Next to each article returned I have a check box, I'm using this check box "true" condition to return the written article if checked, if not checked then it should look at the row below and so on. Please see the images below. I'm also open to a VBA code if anyone can come up with it.

Please note: in my sheet only 1 check mark can be selected at a time, not multiple selections.

This is the formula I'm using "Note" the semicolon ";" is a must due to the region I'm working from (Latin America), a comma won't work.

This is the first Vlookup that works perfect, it see the check mark "true" condition in C4 and looks up B4 returning the data stored in the article sheet.

Sample below pertains to C5 amd C6 checked "true" but returns a " 0 ".

I really hope you guys can help me with this issue. I appreciate your time and all comments are welcome.

 

[SemperFi]

Hi Alex,
My apologies for not answering right away.
Yes, I made a second excel sheet with an additional row, and by mistake I sent you the wrong one. The only difference is the new one has an additional row with a vlookup in an effort from my end to see if it would be easier to call out an id vs. a full sentence would be easier. Let me try your last code. Unfortunately I'm using right now a work computer that has sharing capabilities and download blocked.
Thank you for your help, I really appreciate it.

 

[SemperFi]

Hi Alex
thank you for getting back to me. you're right I sent the wrong excel. The one you got has an additional column in my effort to try to find a solution. I did used the formula you sent last and it worked only for the first check mark. See image below:

Note: Column C is actually pulling an article id, located in the article sheet column see (article sheet screenshot below)
Column D is a simple if statement when check box is marked I get a 1
Both columns c and d are not needed, this is just me trying to find a solution, thus removing it is not an issue

First check box - checked

Second and third box gets the same result

This is the Article data

 

[Alex Blakenburg]

To me it looks like it is working.
If the 2nd checkbox is true, it uses 1204 to do a lookup. Column D in the mapping table is empty. so it returns a zero.
Similarly for checkbox 3, it uses 1206 which ia also blank in column D and also returns a zero.
Try putting a value in the mapping table in column D for 1204 & 1206

 

[SemperFi]

How did I miss that!
You know what you are - BRILLIANT!
Thank you so much Alex without you this task would have been impossible. Thank you a million, just brilliant man ??.
Pedro
Semper Fi

 

[Alex Blakenburg]

LOL. Where I live we are in lockdown at the moment, your feedback may well be the highlight of my day.

 

[SemperFi]

I'm glad to hear that, you deserve it! Stay safe and remember lockdown is only for a while - dead is forever! Take care of yourselve.