Function question:

S

Sahrens1

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?
 
B

Bob Phillips

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)
 
S

Sahrens1

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


Thanks.
 
B

Bob Phillips

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)
 
Top