Override lookup values.

[sungen99]

F7 will be a pre loaded number but the client has the ability to override that number by selecting a new number via drop down in F7. IF a client DOES select a number I need the G7 slot then to perform a lookup of the new response.

However, the client ALSO has the ability to CHANGE the LOOKUP value in G7 thereby wiping out the formula that currently resides there.

I would like to not have to require the client to have to click a "reset" button or something like that to reset the formulas and return the override to null.

Any ideas on how to make this work better?

[Bernie Deitrick]

Use E7 for the default, and F7 for the client, and in G7 use this formula

=VLOOKUP(IF(F7<>"",F7,E7),A1:B10,2,FALSE)