Hi guys,

basically I need a way of locating a name along a specified row and
returning the value n rows below that name.

For example I have a target cell with a dropdown list, when I select a name
(ie "Dog") in that list I then need excel to identify this somewhere along
row B and return the value that is two rows below it.

Any help would be warmly appreciated.

Many thanks in advance.

Kind regards,

Anthony