I'm looking for a cell function that will search all the colums in a given
worksheet for a specific value and then auto populate the cell with the
values of an adjacent cell to the ones found. If it doesn't find a a match
in one row then it keeps looking through other rows until it does find one
and then populates.

Example:

Col A ---- Col B ---- Col C
1 --------- ready ------Changed
2 --------- ready ------Changed
3 --------- not r ------un-Changed
4 --------- ready ------Changed
5 --------- almost ------un-Changed


So with the above if I wanted the cell values of Col B for each un-Changed
in Col C then the return on another worksheet would be ...
Col A
row 1 not r
row 2 almost



Thanks In Advance,
Rob