Please get your terminology correct, Anthony - there is no row B, as B is a
column. Rows have numbers associated with them. It makes it very difficult
to know what you want if you mix these things up.

Pete

"Anto111" wrote in message
...
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