=If(and(F2=21010009,U2=F), 21060201,"")

Vaya con Dios,
Chuck, CABGx3



"punter" wrote:


Hi,

Having an issue with an IF statement. I'm running the formula in
column G (blank column). What I want it to do is read column F, if the
number 21010009 is in there I then want it to read column U, if there is
an F in there I want it to return the number 21060201 in Column G.

I tried a couple of different combinations like this:
=If(F2=21010009,U2=F), 21060201). None of my combos so far have pulled
in what I want. Any ideas?


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=553566