VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE

[ORLANDO VAZQUEZ]

Hi,

How can I re-word the vlookup in A3 below so that when cell A1 value changes
then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2,
Fixed1, Alternative4, etc..

A B C

1 Equity1 [this is a formula referring to the tab name and subject to
change]


2 11/30/2008

3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE)


Thank you.

 

[Dave Peterson]

The sheetnames are in A1?

=VLOOKUP(A2,Indirect("'"&a1&"'!B10:Q561"),3,FALSE)

Hi,

How can I re-word the vlookup in A3 below so that when cell A1 value changes
then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2,
Fixed1, Alternative4, etc..

A B C

1 Equity1 [this is a formula referring to the tab name and subject to
change]

2 11/30/2008

3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE)

Thank you.

 

[ORLANDO VAZQUEZ]

That's works great!
Thank you Dave !

--
Orlando Vazquez

The sheetnames are in A1?

=VLOOKUP(A2,Indirect("'"&a1&"'!B10:Q561"),3,FALSE)

Hi,

How can I re-word the vlookup in A3 below so that when cell A1 value changes
then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2,
Fixed1, Alternative4, etc..

A B C

1 Equity1 [this is a formula referring to the tab name and subject to
change]

2 11/30/2008

3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE)

Thank you.

 

[ORLANDO VAZQUEZ]

Perfect fix.
Thank you
--
Orlando Vazquez

The sheetnames are in A1?

=VLOOKUP(A2,Indirect("'"&a1&"'!B10:Q561"),3,FALSE)

Hi,

How can I re-word the vlookup in A3 below so that when cell A1 value changes
then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2,
Fixed1, Alternative4, etc..

A B C

1 Equity1 [this is a formula referring to the tab name and subject to
change]

2 11/30/2008

3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE)

Thank you.

 

[ORLANDO VAZQUEZ]

Thank you!
I have a related question please if you have time...

====
In a macro such as ....Application.Goto Reference:="abc"
where "abc" equals the results of the formula in cell a1

I want to goto location specified by the formula in cell A1.

For example if cell A1 formula result = equity1
When I run this macro I want to goto range "equity1"


Please let me know.

Thank you.

Orlando

I want to goto the range named "equity1"




--
Orlando Vazquez

The sheetnames are in A1?

=VLOOKUP(A2,Indirect("'"&a1&"'!B10:Q561"),3,FALSE)

Hi,

How can I re-word the vlookup in A3 below so that when cell A1 value changes
then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2,
Fixed1, Alternative4, etc..

A B C

1 Equity1 [this is a formula referring to the tab name and subject to
change]

2 11/30/2008

3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE)

Thank you.

 

[Dave Peterson]

Application.goto range(range("a1").value).value

Thank you!
I have a related question please if you have time...

====
In a macro such as ....Application.Goto Reference:="abc"
where "abc" equals the results of the formula in cell a1

I want to goto location specified by the formula in cell A1.

For example if cell A1 formula result = equity1
When I run this macro I want to goto range "equity1"

Please let me know.

Thank you.

Orlando

I want to goto the range named "equity1"

--
Orlando Vazquez

The sheetnames are in A1?

=VLOOKUP(A2,Indirect("'"&a1&"'!B10:Q561"),3,FALSE)

Hi,

How can I re-word the vlookup in A3 below so that when cell A1 value changes
then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2,
Fixed1, Alternative4, etc..

A B C

1 Equity1 [this is a formula referring to the tab name and subject to
change]

2 11/30/2008

3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE)

Thank you.

 

[ORLANDO VAZQUEZ]

How should I format data in cell A1.

I currently have A! as: Equity1!A477

Where equity1 is the tab and A477 is the cell I want to go to and I figured
I needed an exlamation in the middle?

Thank you so much.


--
Orlando Vazquez

Application.goto range(range("a1").value).value

Thank you!
I have a related question please if you have time...

====
In a macro such as ....Application.Goto Reference:="abc"
where "abc" equals the results of the formula in cell a1

I want to goto location specified by the formula in cell A1.

For example if cell A1 formula result = equity1
When I run this macro I want to goto range "equity1"

Please let me know.

Thank you.

Orlando

I want to goto the range named "equity1"

--
Orlando Vazquez

The sheetnames are in A1?

=VLOOKUP(A2,Indirect("'"&a1&"'!B10:Q561"),3,FALSE)



ORLANDO VAZQUEZ wrote:

Hi,

How can I re-word the vlookup in A3 below so that when cell A1 value changes
then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2,
Fixed1, Alternative4, etc..

A B C

1 Equity1 [this is a formula referring to the tab name and subject to
change]

2 11/30/2008

3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE)

Thank you.

 

[ORLANDO VAZQUEZ]

I got rid of the last . value and it works.

Thanks.

--
Orlando Vazquez

Application.goto range(range("a1").value).value

Thank you!
I have a related question please if you have time...

====
In a macro such as ....Application.Goto Reference:="abc"
where "abc" equals the results of the formula in cell a1

I want to goto location specified by the formula in cell A1.

For example if cell A1 formula result = equity1
When I run this macro I want to goto range "equity1"

Please let me know.

Thank you.

Orlando

I want to goto the range named "equity1"

--
Orlando Vazquez

The sheetnames are in A1?

=VLOOKUP(A2,Indirect("'"&a1&"'!B10:Q561"),3,FALSE)



ORLANDO VAZQUEZ wrote:

Hi,

How can I re-word the vlookup in A3 below so that when cell A1 value changes
then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2,
Fixed1, Alternative4, etc..

A B C

1 Equity1 [this is a formula referring to the tab name and subject to
change]

2 11/30/2008

3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE)

Thank you.