Use the HLOOKUP function in cell H9 to calculate the product pricing based on the color and quantity of the billboards ordered. Product pricing can be referenced on the "Product Pricing" lookup table (range O9:Q18). Be sure to use appropriate relative and absolute cell references
Here is the Excel HyperLink, click over the tabs to "lookup functions", you will find where i'm struggling under cell h9 price.
What I have Which is wrong:
D9 lookup value refers to #shipped
I have no problem with vlookup but i'm struggling to put in the lookup value and row index number in the right spot for hlookup.