Okay, I am sure I am an idiot, but I want to copy the value of another
cell, based on the value of my target cell.

Example:
Formual in Cell L1

If Cell k1 equals P1, I want to copy the value(text) of zz99 to cell
l1. Anyone know the answer to this?

with a formula in cell l1, try
=if(k2=p1,zz99)

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Okay, I am sure I am an idiot, but I want to copy the value of another
cell, based on the value of my target cell.

Example:
Formual in Cell L1

If Cell k1 equals P1, I want to copy the value(text) of zz99 to cell
l1. Anyone know the answer to this?

In I1

=IF(K1=P1,ZZ99,"")

I assume ZZ99 is a 20076 cell?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
oups.com...
Okay, I am sure I am an idiot, but I want to copy the value of another
cell, based on the value of my target cell.

Example:
Formual in Cell L1

If Cell k1 equals P1, I want to copy the value(text) of zz99 to cell
l1. Anyone know the answer to this?

AWESOME, I got it... The P1 needs to be in quotes, so the formula
would read:
=if(k2="p1",zz99)


Thanks.

LOL! I thought it was a cell reference.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
oups.com...
AWESOME, I got it... The P1 needs to be in quotes, so the formula
would read:
=if(k2="p1",zz99)


Thanks.

me too

--
Don Guillett
SalesAid Software

"Bob Phillips" wrote in message
...
LOL! I thought it was a cell reference.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



wrote in message
oups.com...
AWESOME, I got it... The P1 needs to be in quotes, so the formula
would read:
=if(k2="p1",zz99)


Thanks.