View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stuart Bray Stuart Bray is offline
external usenet poster
 
Posts: 4
Default vb for nested if with more than 7 statements

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.