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.


--
zangief
------------------------------------------------------------------------
zangief's Profile: http://www.excelforum.com/member.php...o&userid=27560
View this thread: http://www.excelforum.com/showthread...hreadid=471000