I am trying to write a formula that will look at H14:H20 & R14:R20 to look for an "X", if there is an X in one of those boxes I want it to copy the number in E14:E20 & O14:O20 in the corresponding row. I had it once but think that I stumbled on it by accident and when IT upgraded the software to 2003 from 2000 it got "lost in translation" and now that is the only formula that does not work. Please help,
Thanks
John
Thanks
John