Firstly, apologies if the thread title is wrong but I'm not sure of the best way to describe my question.

I have a worksheet which uses the formula below to extract data from the 'All authority data' worksheet and place it in columns in sheet1

Column D in sheet1 contains data on a organisation and D6 contains that organisation's geographical region (which can be selected by a user). What I'm doing is displaying the same information for other organisations in the same region alongside it. The formula finds each data row in the All authority sheet for that region and displays the value in the first column (B) in sheet1. The formula is in five cells as there are multiple matches, with the bold number different in each (1,2,3,4,5).

I have one question. Are there non-VBA solutions?

1. The formula obviously picks up the original organisation specified in column D so it appears twice: is there a way of avoiding this?

Hope my explanation hasn't completely baffled everyone.

Stephen