Search and replace
 

I have three things in three columns, A, B,c.
The first is a letternumber combination, i.e.
a-1
a-1
a-1
b-1
b-1
b-1
The second is the object in question for a-1, so: test1, test2, test3
which is repeated for b-1. Some tests are positive, and designated by a
1 for + and a 0 for negative in column C. However, if there is a
positive for any test, i need all of the test results to be displayed
(the results are in column D). Right now, with some help, i can get
excel to read the information and output all results that have a 1 on a
second sheet.

How could i get excel to see which results are positive and the output
all results (the column D numbers) to a sheet. Maybe a vllokup of the
values on column d that replaces the 0 in sheet one with a 1?
thanks,

Sam