Return value of the cell to the right...

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

 

[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

 

[zangief]

it doesn't seem to be working

I think the offset function is what I need thoug

 

[Rowan]

How about:

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

Regards
Rowan