SPSW - Coursework from BPP - Kitchens

Adele69

For those who have done the Spreadsheet Software module with BPP books and course material. I'm struggling through the question on Kitchens, as part of the additional coursework. We got a handout with the questions, the files and a printout of answers. The printout of the answer has no formulas, so no real help in getting the answer.

The Kitchens workboot comprises four worksheets: Order Details, Types, Prices and Data. The last can be ignored as this was copied into prices as part of the earlier tasks. In the Order Details sheet there are two tables. The first table has a cell C5 for Style (these are listed in types: 2 = White, 3 = Pine, 4 = Beech, 5 = Oak, 6 = Teak). The second table has several columns for Unit, Description, Quantity, Price, Total Price. Unit and Description are defined, the others are calculated from lookups and sums.

The Price is based on the value in Prices, and the particular column is based on Type, so a lookup within a lookup, but I'm getting a value error presumably because one lookup is showing text not number. This was my formula attempt which gave me an error.

=VLOOKUP(B8,Prices!A3:H36,(VLOOKUP('Order Details'!$C$5,Types!$A$3:$B$8,2,FALSE)),FALSE)

I have an exam on Tuesday. Last week was college half term (same holidays as schools - really inconvenient). I was fairly confident after doing the AAT practice assessment before looking at this, and without the answers my confidence has evaporated.

image of Kitchens worksheets on Photobucket