Need a lookup to extract data table based on four criteria & override user input

David,

Once again, thank you so much for your help . You are the man! I cannot express how much I am impressed by your ability to put this together. After testing the quote template, I have some requests and questions. All NEW comments are highlighted in blue in the attached file.1). If I go through the Calculation sheet in order it works pretty well. However, if I have already selected the Reeving (C5), Capacity (C6), and Model (C7) but then change the Capacity again...the "Display Table" (G13:O13) is not updated. I have saved the the attached worksheet to show this and included new comments. I am actually using the price shown from the top row of the display table so a client could potentialy not realize that they hadn't changed the model number (after changing the Capacity) and the display table would show the wrong price. The Trolley selection (C8 on the Calculation sheet) works ok because if the user selects a trolley size or type that is not available with the selected Capacity and Model, because a zero is shown. In other words, if only one row is displayed in the "Display Table" then the data displayed needs to be blank (show error?) or match the criteria shown in all cells C5:C8. Hope this makes sense.

2). On the equipment net weight (quote tab) the lookup is only looking up the "base mount" weight, There are three trolley choices (each trolley type has a different weight) which are based on the user selection in cell C8 on the calculation sheet. You will notice on both "Spec" sheets that there is a "weight" column for "base mount", Monorail, and Double Girder. The Double Girder refers to all of the trolleys that are referenced by sizes such as 49 1/4, 55 1/8, etc...

3). Is there a way to highlight a cell if it has been overriden? If so, I would like for all cells that have been overriden to be highlighted until the formulated value is shown again. This way we can tell if something is has been changed by a user. Also, it would be nice if all of the cells that were overrided would go back to the formulated value after the quote template has been closed and re-opened.

4). Last but not least. The VBA change event does not seem to be working. I thought it was working initially but I am not sure if it is something I have done. The cell does not revert back to the formulated value. I changed a reference in a cell on the "Quote" tab so maybe that messed it up? I looked at the debugging option but am not familiar enough with VBA to figure how to get the code back to where it needs to be. I will be locking many of these cells before I send the template out to the client but it would be nice to understand how to get the VBA corrected in case I accidentally do it again.

Thanks again for your time and expertise!
Marvin