| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hlookup problem in knowing what range to use
Sounds like your table is actually in A3:F8. Hlookup tries to match the risk
factor to the values in the first row of the range you specify, then returns a value in the nth row of the table (the 6 below indicates the 6th row of the range A3:F8 - which is actually row 8 of the worksheet) Try: =HLOOKUP(C3,'Investment Strategy'!A3:F8,6,FALSE) "Hillary: needing some help" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hlookup problem in knowing what range to use
that was it thank you so much!!
"JMB" wrote: Sounds like your table is actually in A3:F8. Hlookup tries to match the risk factor to the values in the first row of the range you specify, then returns a value in the nth row of the table (the 6 below indicates the 6th row of the range A3:F8 - which is actually row 8 of the worksheet) Try: =HLOOKUP(C3,'Investment Strategy'!A3:F8,6,FALSE) "Hillary: needing some help" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hlookup problem in knowing what range to use
do you have an email i can reach you at for further questions if needed?
"JMB" wrote: Sounds like your table is actually in A3:F8. Hlookup tries to match the risk factor to the values in the first row of the range you specify, then returns a value in the nth row of the table (the 6 below indicates the 6th row of the range A3:F8 - which is actually row 8 of the worksheet) Try: =HLOOKUP(C3,'Investment Strategy'!A3:F8,6,FALSE) "Hillary: needing some help" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hlookup problem in knowing what range to use
Sorry, but I don't generally give out my email address. You are free to post
additional questions in the newsgroup, but since it is for a class you may/may not get responses. "Hillary: needing some help" wrote: do you have an email i can reach you at for further questions if needed? "JMB" wrote: Sounds like your table is actually in A3:F8. Hlookup tries to match the risk factor to the values in the first row of the range you specify, then returns a value in the nth row of the table (the 6 below indicates the 6th row of the range A3:F8 - which is actually row 8 of the worksheet) Try: =HLOOKUP(C3,'Investment Strategy'!A3:F8,6,FALSE) "Hillary: needing some help" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
