I have a list on sheet 1 of two columns of data, A and B. Column A is a list with either a W or L. I would like to search through column A for all fields with a W and copy the entire row for each entry to sheet 2. Is it possible to do this using a variation of VLOOKUP and if so, how?