Hi,

You question is confusing, there is no row B but maybe you mean this

=HLOOKUP(A1,C2:Q12,11,FALSE)

Mike

"Anto111" wrote:

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