• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF function for multiple criterias

F

Fadil

Member
I have a list of items where I need to return in a cover page if criteria matches.
I am asking for help on what would be the best way to present this information.

In directory tab I have list of items in 4 different columns. Now, if criteria matches with cover page data, then to return those items in the cover page, and it could be 3 items for one project, 4 items for other project etc
I can attach a sample if someone is willing to advise

Regards,
Fadil
 
Also, I want to know if I would be able to present this data somehow in a textbox where I would be able to format it in top of the existing format tables so I don't move many things around just to accommodate these four columns at the end of the sheet
 
Hi Fadil,
I think you need to be more specific, try updating your sample with some fake data, and clearly mention your desire result as there is case of duplicate data.

Regards,
 
Fadil, assuming that there were no uniques, i concatenated all the columns first..please validate..used helper Cells to keep it simple..

EDIT:
Once you confirm, it is working fine..shall work on the finishing part of it..
 

Attachments

Hi Fadil,
Enter this in C13 and copy down & across:

=IF(ISERROR(INDEX(Directory!$A$2:$E$20,SMALL(IF(Directory!$A$2:$A$20=$C$10,ROW(Directory!$A$2:$E$20)),ROW(1:1))-1,COLUMN(B1))),"",INDEX(Directory!$A$2:$E$20,SMALL(IF(Directory!$A$2:$E$20=$C$10,ROW(Directory!$A$2:$E$20)),ROW(1:1))-1,COLUMN(B1)))

Note: This is an Array Formula which must be entered with Ctrl+Shift+Enter

copy from:

Regards,
 
I will try this to see if I can manage to add this to my sheet. I checked the file and this is what I needed.
 
Hi all,
Thank you very much for your help. It worked perfectly, I was able to add it to my worksheet
Thank you million times

Regards,
Fadil
 
You must log in or register to reply here.
Back
Top