VLOOKUP Row Below Value

[mouse88]

I have data layed out in the format shown below.
I know how to get the data with a VLOOKUP if the data I want is in the same row as the value im looking for but on this occasion it will be on the row below.

Can anyone advise how I can specify the row as well as column?

By the way the look up value is "Agent Name & ID: John Davies - 1234"

Thanks

Matt

 

[VoG]

Maybe

=INDEX(B:B,MATCH(A:A,"Agent Name & ID: John Davies - 1234",0)+1))

 

[mouse88]

Thanks for that.

Am i right in assuming the 0 is the column to lookup and the 1 specifies the row below?

 

[mouse88]

I tried this and I get a #VALUE! error

Edit: got it working now. just had to switch the range and the lookup value around in the MATCH function.

Thanks for this, thought I was going to have a nightmare doing this for 250 employees. Didn't even realise I could reference a whole column using A:A.

Thanks

Matt