do you only want to get a single cell's value -which meets the search criteria- from a closed workbook into a single cell in the open workbbok?