How about:

=VLOOKUP("Rory",H:I,2,0)

Regards
Rowan

zangief wrote:
I have been using the function

=IF(COUNTIF(H:H,"Rory")0,I21,"")

It will return the value of cell of I21 if the name "Rory" is in column
H. I need to know if I can so that instead of returning I21, it can
return the value of the cell to the right of the cell that "Rory" is
in.

Thanks if you can help.