Most valuable professional
  • Hot Topics

Excel Find and dates data across sheets

Hi all, i have a workbook which consists of 2 sheets. in each sheet i have a unique ID and the date next to it such as sheet 1 98531 86521b 66363d sheet 2 86521b 98531 66363d what i need to do is first find the data from sheet 2 which matches sheet 1. then minus sheet two date from sheet 1 to give me the amount of days difference. any help will be much appreciated

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of November 10, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel