ok this is for a class but the teacher didn't not know how to explain it to me.

i am to: Use the HLookup function in cel C4 to display the minimum cash
requirement. The function should look for the Risk Level code showing in cell
C3 on the Portfolio workshet in row 3 of the Investment Strategy worksheet.
The minimum cash requirement are listed for each risk in row 8

PORTFOLIO:
{values that are used will be ***}

Client Investment Portfolio
Risk Level M {C3}
Minimum Required Cash ***{C4}
Current Cash 8000
***{A6} ***{C6}

INVESTMENT STRATEGY:
{values that are used will be ***}

Investment Strategies

Risk Levels VA A M C VC

Bonds 0.00% 10.00% 30.00% 50.00% 80.00%
Mutual Funds 0.00% 20.00% 30.00% 20.00% 20.00%
Stocks 100.00% 70.00% 40.00% 30.00% 0.00%
Cash Minimum $1,000 $5,000 $15,000 $25,000 $35,000

I HAVE NO IDEA WHAT TABLE ARRAY TO SELECT IN ORDER TO MAKE THE FUNCTION WORK
here is what I have so far:

=HLOOKUP(C3,'Investment Strategy'!A1:F8,8,FALSE)

that doesn't yeild anything