took me a while to get it, but worked great, thanks
k

"Stuart Bray" wrote in message
...
Use a vlookup instead of an if.
Put your list of cars and prices on another sheet. Then, in the cell
that needs to change - type:
=vlookup(
You can then use the fx button to guide you through using vlookups.