View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rocko Rocko is offline
external usenet poster
 
Posts: 14
Default Conditional Answer

I have a Job Spec Sheet that i use & I would like to be able to get a
specification based on 4 separate criteria. It would be a useful cross
reference on an area that can easily be done filled in incorrectly. I would
like to do the following:

A1: Overall Height = B1 (Condition 1)
A2: Turntable Height: = B2 (Condition 2)
A3: Flooring: = B3 (Condition 3)
A4: Trailer Type: = B4 (Condition 4)
A5: Rear Opening: = B5 (ANSWER REQUIRED BASED ON ABOVE CONDITIONS)

I hope I have explained myself clearly. Any help would be greatly appreciated.

Thanks in advance