|
VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE
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 |
VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE
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 -- Dave Peterson |
VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE
That's works great!
Thank you Dave ! -- Orlando Vazquez "Dave Peterson" wrote: 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 -- Dave Peterson |
VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE
Perfect fix.
Thank you -- Orlando Vazquez "Dave Peterson" wrote: 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 -- Dave Peterson |
VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE
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" wrote: 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 -- Dave Peterson |
VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE
Application.goto range(range("a1").value).value
ORLANDO VAZQUEZ wrote: 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" wrote: 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 -- Dave Peterson -- Dave Peterson |
VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE
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" wrote: Application.goto range(range("a1").value).value ORLANDO VAZQUEZ wrote: 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" wrote: 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 -- Dave Peterson -- Dave Peterson |
VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE
I got rid of the last . value and it works.
Thanks. -- Orlando Vazquez "Dave Peterson" wrote: Application.goto range(range("a1").value).value ORLANDO VAZQUEZ wrote: 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" wrote: 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 -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 03:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com