In B22 put this formula............

=IF(A22=F400,G400,"")

The "" means if the condition does not exist, then just leave the cell
blank........you could change it to

=IF(A22=F400,G400,"They are not equal")

Vaya con Dios,
Chuck, CABGx3



"LoriM1" wrote:


~Oh gods of formulas, please help me!!! Can you help me with this
formula?~
If a cell in column a equals a cell in column f then insert in
column b the number in column g.
To Clarify:
The number in a22 is equal to the number in f400. The number
in
g400 needs to be placed in b22.

Please make it in Lori language.

Thank you!!!!!!!!!
Lori


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681