software

Not sure if that's possible, but here is the situation I have.

Say I use a formula on a summary tab that pulls numbers from data1,
data2, data3, etc. tabs. In this particular case, I am using VLOOKUP.
So, my formulas will look like this:

Column B---------------------------------Column C
=VLOOKUP(A1,DATA1!A:B,2,0)---------=VLOOKUP(A1,DATA2!A:B,2,0)
...... many rows go here with VLOOKUP

I have to manually adjust references to DATA tabs for each additional
column I add, so I will go and change data1, data2, etc. in VLOOKUP
each time a new column is added. Is there a way to enter DATA1, DATA2,
etc. above columns and then just reference them into the VLOOKUP
function. Like this:

Column B-----------------------------------Column C
DATA1 (-cell B1-)----------------------------DATA2 (-cell C1-)
=VLOOKUP(A1,Ref_to_B1!A:B,2,0)------=VLOOKUP(A1,Ref_To_C1!A:B,2,0)
...... many rows go here with VLOOKUP

I tried using something like _quot;amp;B1amp;quot;!A:Bquot;_ for the second argument in
VLOOKUP, but it does not seem to work.

Any help is greatly appreciated.--
proper
------------------------------------------------------------------------
proper's Profile: www.excelforum.com/member.php...oamp;userid=33166
View this thread: www.excelforum.com/showthread...hreadid=529897Hi!

One way:

=VLOOKUP(A1,INDIRECT(quot;'quot;amp;B1amp;quot;'!A:Bquot;),2,0)

Biff

quot;properquot; gt; wrote in
message news
gt;
gt; Not sure if that's possible, but here is the situation I have.
gt;
gt; Say I use a formula on a summary tab that pulls numbers from data1,
gt; data2, data3, etc. tabs. In this particular case, I am using VLOOKUP.
gt; So, my formulas will look like this:
gt;
gt; Column B---------------------------------Column C
gt; =VLOOKUP(A1,DATA1!A:B,2,0)---------=VLOOKUP(A1,DATA2!A:B,2,0)
gt; ..... many rows go here with VLOOKUP
gt;
gt; I have to manually adjust references to DATA tabs for each additional
gt; column I add, so I will go and change data1, data2, etc. in VLOOKUP
gt; each time a new column is added. Is there a way to enter DATA1, DATA2,
gt; etc. above columns and then just reference them into the VLOOKUP
gt; function. Like this:
gt;
gt; Column B-----------------------------------Column C
gt; DATA1 (-cell B1-)----------------------------DATA2 (-cell C1-)
gt; =VLOOKUP(A1,Ref_to_B1!A:B,2,0)------=VLOOKUP(A1,Ref_To_C1!A:B,2,0)
gt; ..... many rows go here with VLOOKUP
gt;
gt; I tried using something like _quot;amp;B1amp;quot;!A:Bquot;_ for the second argument in
gt; VLOOKUP, but it does not seem to work.
gt;
gt; Any help is greatly appreciated.
gt;
gt;
gt; --
gt; proper
gt; ------------------------------------------------------------------------
gt; proper's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33166
gt; View this thread: www.excelforum.com/showthread...hreadid=529897
gt;
In column B, try:

=VLOOKUP(A1,INDIRECT('DATA'amp;COLUMN()-1amp;quot;!A:Bquot;);2;0)
then drag to the right

HTH
--
AP

quot;properquot; gt; a écrit dans
le message de news
gt;
gt; Not sure if that's possible, but here is the situation I have.
gt;
gt; Say I use a formula on a summary tab that pulls numbers from data1,
gt; data2, data3, etc. tabs. In this particular case, I am using VLOOKUP.
gt; So, my formulas will look like this:
gt;
gt; Column B---------------------------------Column C
gt; =VLOOKUP(A1,DATA1!A:B,2,0)---------=VLOOKUP(A1,DATA2!A:B,2,0)
gt; ..... many rows go here with VLOOKUP
gt;
gt; I have to manually adjust references to DATA tabs for each additional
gt; column I add, so I will go and change data1, data2, etc. in VLOOKUP
gt; each time a new column is added. Is there a way to enter DATA1, DATA2,
gt; etc. above columns and then just reference them into the VLOOKUP
gt; function. Like this:
gt;
gt; Column B-----------------------------------Column C
gt; DATA1 (-cell B1-)----------------------------DATA2 (-cell C1-)
gt; =VLOOKUP(A1,Ref_to_B1!A:B,2,0)------=VLOOKUP(A1,Ref_To_C1!A:B,2,0)
gt; ..... many rows go here with VLOOKUP
gt;
gt; I tried using something like _quot;amp;B1amp;quot;!A:Bquot;_ for the second argument in
gt; VLOOKUP, but it does not seem to work.
gt;
gt; Any help is greatly appreciated.
gt;
gt;
gt; --
gt; proper
gt; ------------------------------------------------------------------------
gt; proper's Profile:
www.excelforum.com/member.php...oamp;userid=33166
gt; View this thread: www.excelforum.com/showthread...hreadid=529897
gt;

It worked. Thanks guys--
proper
------------------------------------------------------------------------
proper's Profile: www.excelforum.com/member.php...oamp;userid=33166
View this thread: www.excelforum.com/showthread...hreadid=529897You're welcome. Thanks for the feedback!

Biff

quot;properquot; gt; wrote in
message news
gt;
gt; It worked. Thanks guys
gt;
gt;
gt; --
gt; proper
gt; ------------------------------------------------------------------------
gt; proper's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33166
gt; View this thread: www.excelforum.com/showthread...hreadid=529897
gt;