A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

vlookup table_array reference listed in another cell



 
 
Thread Tools Display Modes
  #1  
Old December 12th, 2003, 05:38 PM
external usenet poster
 
Posts: n/a
Default vlookup table_array reference listed in another cell

If anyone can help with this vlookup question I would
appreciate your input. I am trying to place in the
vlookup function
(VLOOKUP(lookup_value,table_array,col_index_num,FA LSE), a
cell reference in each of the parameters (i.e. vlookup
(b5,b6,b7,false)) where the lookup_value is in b5, the
table_array name is in b6, and the col_index is in b7. I
can only get it to work with using cell references for
the parameters b5 & b7. I have to put the actual
parameter for b6 (table_array) in the formula itself.
Any ideas how I can get it to take the table array from
the referenced cell?

Thank you -- James Dean
  #2  
Old December 12th, 2003, 06:24 PM
Aladin Akyurek
external usenet poster
 
Posts: n/a
Default vlookup table_array reference listed in another cell

=VLOOKUP(B5,INDIRECT(B6),B7,0)

wrote in message
...
If anyone can help with this vlookup question I would
appreciate your input. I am trying to place in the
vlookup function
(VLOOKUP(lookup_value,table_array,col_index_num,FA LSE), a
cell reference in each of the parameters (i.e. vlookup
(b5,b6,b7,false)) where the lookup_value is in b5, the
table_array name is in b6, and the col_index is in b7. I
can only get it to work with using cell references for
the parameters b5 & b7. I have to put the actual
parameter for b6 (table_array) in the formula itself.
Any ideas how I can get it to take the table array from
the referenced cell?

Thank you -- James Dean



  #3  
Old December 12th, 2003, 06:25 PM
Paul
external usenet poster
 
Posts: n/a
Default vlookup table_array reference listed in another cell

wrote in message
...
If anyone can help with this vlookup question I would
appreciate your input. I am trying to place in the
vlookup function
(VLOOKUP(lookup_value,table_array,col_index_num,FA LSE), a
cell reference in each of the parameters (i.e. vlookup
(b5,b6,b7,false)) where the lookup_value is in b5, the
table_array name is in b6, and the col_index is in b7. I
can only get it to work with using cell references for
the parameters b5 & b7. I have to put the actual
parameter for b6 (table_array) in the formula itself.
Any ideas how I can get it to take the table array from
the referenced cell?

Thank you -- James Dean


What you have in B6 is some text. You know that it's a name representing a
range, but Excel doesn't. You have to tell Excel to convert the text to a
range, which you can do with INDIRECT. So try:
=VLOOKUP(B5,INDIRECT(B6),B7,FALSE)


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.