Hmmm...

I read "P35" as meaning "P35" and not $P$35.

Guess I was wrong.

Biff

-----Original Message-----
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.

.