Ryan, maybe one of the MVP's has a better solution, but the only way I can
think of doing it is to use a helper column in sheet 1 and Paste Link its
cells to sheet 2. For example, you could use: =IF(B6=1,"over","") and then
copy and Past Link this cell to sheet 2, C12.
--
Sincerely, Michael Colvin


"Ryan" wrote:

I am trying to create an IF formula where the data entered on sheet one, has
the result posted on sheet two. For example, if B6 on sheet 1 = 1, than C12
on sheet 2 = OVER.
--
Thanks
Ryan