View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
punter
 
Posts: n/a
Default Different day, different IF issue


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