Looking up item descriptions where a quantity was selected

[James Eberts]

On one worksheet, SAS tab, a dealer can select options in a cell by putting in a quantity of how many of the option they want. For example, if they want 1 with the description as "3500# Brake Axle w/Breakaway Kit (3500#GVWR)", they type in a "1" in the appropriate cell to select that option. After doing this for all the options they want, I need to create a list of all the items on another worksheet, SAS PRINT SHEET tab, where columns for Quantity, Items Selected, and Cost are shown. From the information on the SAS tab, the Quantity of 1, its description and the cost all need to appear in the appropriate columns.

I have tried to use Vlookup nested in an IF statement and no luck. I also tried a sample of a formula from a sample online that I thought would work, but kept getting a #NUM error. It does not seem that hard to do, but my knowledge of Excel formulas is obviously not enough to make this work. Attached is a portion of the file that I am working on. Any help would be appreciated!

[protonLeah]

Your merged cells make writing formulas more difficult than they have to be.
quantity:

Please Login or Register  to view this content.

desr:

Please Login or Register  to view this content.

cost:

Please Login or Register  to view this content.

---

sas.code =SAS!$C$36:$C$54
sas.cost =SAS!$K$36:$K$54
sas.description =SAS!$D$36:$J$54
sas.itemselector =SAS!$B$36:$B$54
sas.models =SAS!$A$6:$B$15
sas.options =SAS!$B$36:$K$54