Overview Sheet of Action List

[passman86]

Hi there,

Long time no post, but still messing with excel.

I have created a new action/progress list at my company. In the list, jobs are displayed view description, who is responsible, start date, expected duration and priority (HIGH, MED, LOW).

It all looks lovely and is nice and simple to understand and follow. But, my boss wants to have an overview sheet at the front of the workbook to save him the 10 seconds it takes to click through the 6 different tabs at the bottom.

He wants the overview to show only the HIGH priority jobs, date of review and who is responsible for it. Unfortunately, the jobs don't have a unique identifier, so my idea of VLOOKUPS doesn't seem to work.

I have a sample spreadsheet to show what I have, but its not allowing me to do it, so I have attached some jpegs of what I have done and what I want to do.

Any help appreciated and many thanks in advance.

JPActon List 1.jpg

Overview 1.jpg

[avk]

You can extract data using "index match" formula.
Look attach file. (sheet1 is data bank & sheet2 required data extract)
Ensure this is array formula Hold keys [SHIFT+CTRL+ENTER]

[passman86]

Fantastic, works a treat.

Much appreciated.