If B1 is to display a value, then B1 must contain a formula.

It's not entirely clear to me what the relationship between 9900012 and P35 is
(if any), and what you want to see in B1 if the value isn't found, but
if P35 contains the number 99000012, you could use this formula in B1:

=IF(MATCH(P35,A:A,0),P35,"not found")


On Thu, 3 Feb 2005 20:47:06 -0800, "SingaporeSling"
wrote:

I want to search a column for a specific value. On finding it I want to
populate a cell in another column with another defined value. Example:
search finds value in A1 (say 99000012) and populates B1 with new value (say
P35) where 99000012 will always equal P35. My spreadheet is 6500 lines I
have 5 values to identfy and set corresponding new values in the new column.