In Cell B22

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"LoriM1" wrote in
message ...

~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