Lookup data in a column.

[holli]

test 3.xlsx

My spreadsheet is attached for reference.

I have a simple table to record the dates of staff training this is located on the first worksheet "Fieldwork Training Data".

In the second worksheet "Fieldwork Training" I want to search this table using a drop down box in cell B3. I would like to pick a training type from the dropdown box and find the all the dates and names of the staff who completed that training.

It appears to be a simple problem but I just cant figure out the best way to make it work.

[Richard Buttrey]

Hi,

You would simplify this and make it far more flexible if you changed your layout and recorded all the information in three columns
Date
Staff Name
Training Type

The staff name and training type columns could be drop down validation boxes so that yuo can quickly select names or training types. Once you have this layout you'll open the wonderful world of Pivot tables.

However the attached will do the task with a simple filter macro.

[azumi]

Different approach with array formula......


regards

[holli]

Thanks to you both for the help it is greatly appreciated. I am much more confident with formulas than macros so I will give that a whirl.