'IF' formula trouble

Hi everyone. I'm having trouble with a formula for figuring out if a row is found within another column. I know that there's a simple solution, but I'm just not getting it right. Thanks in advance for any help!

Hi--rows aren't found in columns.

I'm not sure what you're asking here, but the general format for IF
functions is:

IF A, B, ELSE C.

Example:

A1= 10
B1= 2
C1= A1*B1

In D1 you could put a formula: =IF(A1=9+1,C1,B1) which would return 20
(A1*B1).

In plain English: If A1 = 9 + 1, THEN return the value in C1, ELSE return
the value in B1.

"agw3" wrote:

>
> Hi everyone. I'm having trouble with a formula for figuring out if a row
> is found within another column. I know that there's a simple solution,
> but I'm just not getting it right. Thanks in advance for any help!
>
>
> --
> agw3
> ------------------------------------------------------------------------
> agw3's Profile: http://www.excelforum.com/member.php...o&userid=37284
> View this thread: http://www.excelforum.com/showthread...hreadid=569914
>
>

Please restate your question, I do not know what you want to do.

"agw3" wrote:

>
> Hi everyone. I'm having trouble with a formula for figuring out if a row
> is found within another column. I know that there's a simple solution,
> but I'm just not getting it right. Thanks in advance for any help!
>
>
> --
> agw3
> ------------------------------------------------------------------------
> agw3's Profile: http://www.excelforum.com/member.php...o&userid=37284
> View this thread: http://www.excelforum.com/showthread...hreadid=569914
>
>