Can the match be anywhere in the worksheet(s), or is it limited to certain
ranges?

Bernie


"new_to_vba" wrote in message
...
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.