Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hlookup problem in knowing what range to use
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with HLookup. Not sure if it is a bug or not | Excel Worksheet Functions | |||
hlookup problem | Excel Discussion (Misc queries) | |||
hlookup problem | Excel Discussion (Misc queries) | |||
fill in data range knowing start and end values | Excel Worksheet Functions | |||
Problem with application.Hlookup | Excel Discussion (Misc queries) |