Hi There,
I need help in creating a list from the attached table.
Need an Index/Match function that will bring over the first item from column A (page name) that matches the Quote Type and if a "Yes" is in Column D (QC Impact (yes/no). Then, need the next line (and so on) to bring over the next item from column A (page name) that matches the same criteria.
Attachment with sample data and expected outcome in the attachment.
Thank you ahead of time for the help
Bookmarks