VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE

O

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.
 
D

Dave Peterson

The sheetnames are in A1?

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



ORLANDO said:
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.
 
O

ORLANDO VAZQUEZ

That's works great!
Thank you Dave !

--
Orlando Vazquez


Dave Peterson said:
The sheetnames are in A1?

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



ORLANDO said:
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.
 
O

ORLANDO VAZQUEZ

Perfect fix.
Thank you
--
Orlando Vazquez


Dave Peterson said:
The sheetnames are in A1?

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



ORLANDO said:
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.
 
O

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


Dave Peterson said:
The sheetnames are in A1?

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



ORLANDO said:
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.
 
D

Dave Peterson

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



ORLANDO said:
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

Dave Peterson said:
The sheetnames are in A1?

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



ORLANDO said:
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.
 
O

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


Dave Peterson said:
Application.goto range(range("a1").value).value



ORLANDO said:
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

Dave Peterson said:
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.
 
O

ORLANDO VAZQUEZ

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

Thanks.

--
Orlando Vazquez


Dave Peterson said:
Application.goto range(range("a1").value).value



ORLANDO said:
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

Dave Peterson said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top