Working on a project for a class and I don't totally understand the hlookup function.
This is what it tells me to do
Use the HLookup function in cell C4 to display the minimum cash requirement. The function should look for the Risk Level code showing in cell C3 on the Portfolio worksheet in row 3 of the Investment Strategy worksheet. The minimum cash requirements are listed for each risk level in row 8.
Now I thought I had a handle on it but I keep getting a REF error.
This is what it tells me to do
Use the HLookup function in cell C4 to display the minimum cash requirement. The function should look for the Risk Level code showing in cell C3 on the Portfolio worksheet in row 3 of the Investment Strategy worksheet. The minimum cash requirements are listed for each risk level in row 8.
Now I thought I had a handle on it but I keep getting a REF error.