False if no change

[ksuechuc]

How do I get a cell to not change value if the IF statement returns FALSE?

eg.

I have a drop down list that makes reference to a set of names and another drop down list that makes reference to a set of weeks. When I select a specific name and week from the drop down lists, they will apply an entered value into the intersecting cell of the selected name and week. However, I don't want the value to change when I select a different name or week unless the name and week are the correct ones.

[mewingkitty]

unless the name and week are the correct ones

It may help if you describe that more in detail. Date-based functions are usually very specific to individual criteria.

Could you post an example worksheet?

[ksuechuc]

My issue here is this,

If I select a valid name and race, and I enter values for the laps into the calculator, the formula will enter whatever value is in the Average field. However, as soon as I change the value in either the Name drop-down or the Race drop-down, I will get a FALSE value in the cell that I was previously making changes to.

So how would I be able to set this up so that the values in the chart stay the same unless the 2 values from the drop-down menus meet the exact criteria to have a change happen.

Thanks