Hi i have alot of data in sheet 3 of my work book. on sheet2 of my workbook i have a cell with a value in it. My question is is there a formula to search through all the cells in column A in sheet 3 and return B and C in all rows that correspond to the value in the cell in sheet2. For instance...