http://www.flatworldknowledge.com/sites/all/files/ManzoExcel_1.0_Chapter_3_Skills_Test.xlsx

1. On thePortfolio Summaryworksheet, use the HLOOKUP function to display the Portfolio Target in cell E3. The function should look for the Investment Type in cell A3 in Row 2 of thePortfolio Targetsworksheet. The function should display the percentage in the Moderate row (Row 5) for each investment type. The function should look for an exact match to the lookup value. Consider that this function will be copied and pasted into the range E4:E6 when defining the arguments.

I need help with how to format the function