Function question:

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sahrens1@gmail.com - 26 Mar 2007 18:40 GMT

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?

Reply to this Message

Don Guillett - 26 Mar 2007 18:48 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.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.
[quoted text clipped - 4 lines]
> If Cell k1 equals P1, I want to copy the value(text) of zz99 to cell
> l1. Anyone know the answer to this?

Reply to this Message

Bob Phillips - 26 Mar 2007 18:50 GMT

In I1

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

I assume ZZ99 is a 20076 cell?

Signature

HTH

Bob

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

Reply to this Message

Sahrens1@gmail.com - 26 Mar 2007 19:19 GMT

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

Thanks.

Reply to this Message

Bob Phillips - 26 Mar 2007 21:12 GMT

LOL! I thought it was a cell reference.

Signature

---
HTH

Bob

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

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

Reply to this Message

Don Guillett - 26 Mar 2007 21:26 GMT

me too

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> LOL! I thought it was a cell reference.
>
[quoted text clipped - 3 lines]
>>
>> Thanks.

Reply to this Message