Index and Match and multiple results

[mike2bf]

Hi all

In the attached spreadsheet I need to return multiple values from entering a single value common to the results.

In the drop down box in D2 you select a location and the fields below name etc I need to be populated. The data is stored in another tab called working area.

Can anyone help?

Cheers

Mike

[StephenR]

Try this monster in B6 and copy across and down. Enter as an array formula, with Ctrl+Shift+Enter:

Please Login or Register  to view this content.

You could make this a little less monstrous by using named ranges.

[mike2bf]

Many thanks, spot on!
Mike