Return value of the cell to the right...

Z

zangief

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.
 
D

duane

Note you have to define a row range to find rory in

=offset(i1,match("Rory",H1:h10000,0)-1,0)

I assume you are looking for content in column
 
Top