I am trying to compile a list from a spreadsheet using one specific criteria but taking information from other columns on that sheet on rows where the criteria is met. Below is an example which will hopefully explain better what I am trying to do:
A B C D E
1 Jones Red Day Car Good
2 Davies Green Night Car Excellent
3 Evans Blue Day Bus Good
I want to create a list of all those rows where "Good" is in column E. But I only want to include the data from columns A,C and D in the list for the rows that meet the criteria.
I have probably made this as clear as mud, but I really would appreciate any assistance in this.