lookup in 1 workbook to get data for another workbook
 

Hi everybody. i need to return a date from another workbook based upon the
cell reference in the first workbook. the formula needs to be able to search
4 sheets in the second workbook for an exact match to the reference in the
first book and then return the date (which is in the column prior to the
match)
can this be done? thank you in advance for any help.