Most valuable professional
  • Hot Topics

Excel Formula to pull last date (of many) from data sheet into main workbook

Hi all, I have a question, I have a tracking sheet that tracks decision and dates, this sheet feeds into a mater workbook that has s decision and decision date columns. The problem/question is, that there can be reschedules, appeals, etc so there could be more than one decision date (in the tracking sheet). In some situations there may just be ONE decision, in others there can be two or three. I need the master tracker to only pull the final decision and date (so I would need it to look in all columns and only pull the latest entries) The tracking sheet looks like this ID 123456 234578 789457 The master sheet appears as below ID 123456 234578 The current formula (below) is a Vlookup that looks the persons ID and then the decision and date - This is the formula I inherited along with the workbook

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

This thread is current as of May 14, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel