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

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

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

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

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