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

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 i


--
duane


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

it doesn't seem to be working

I think the offset function is what I need though


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

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.