Stuck on excel lab using hlookup and vlookup.Write an Excel formula in cell Models!H3 to determine the base price for the Classic European home. This formula should also work when you copy it down to determine the base price for the New American Home, CSE Favorite, etc. Recall that the base price for each model depends on the number of levels and total square footage of the home. ($/SF for all combinations of stories) Square footage can be found in the Base worksheet.

1st image is the output, 2nd image is the source info, total cell range for the 2nd image is B1:H4

I know using hlookup and vlookup the header cells are not included in my ranges.

In Cell H3 of the 1st image my formula is: (Base! is 2nd image)

MUST use H/V lookups, no "IF" statements

=VLOOKUP(D3,Base!$C$2:$H$4,HLOOKUP(C3,Base!$C$2:$H$4,2,TRUE),FALSE)

Any assistance would be GREATLY appreciated!!

\begin{tabular}{|c|r|c|l|c|c|c|} \hline \multicolumn{8}{|c|}{ Standard Features } \\ \hline Model Letter & Square Footage & # Levels & Basement Type & # Bedrm & # Bathrm & Base Price \\ \hline A & 1,750 & 2 & Crawlspace & 3 & 2 & #REF! \\ \hline B & 2,370 & 2 & Full & 4 & 3 & #REF! \\ \hline C & 1,220 & 1 & Crawlspace & 3 & 2 & #REF! \\ \hline D & 1,860 & 1 & Partial & 3 & 1.5 & #N/A \\ \hline E & 3,150 & 2 & Full & 4 & 3.5 & #N/A \\ \hline \end{tabular}