Vlookup

[jcijames]

Is there a way to use the vlookup table for multiple table_arrays?

For instance I want to look up a paygrade (32) but I want to serch through various salary grade tables based on different cities.

I tried =vlookup(32,B10,d2)

32 = salary grade
b10 = a cell reference to the salary table I want it to lookup (I have 7 total) then the d2 is a cell reference to the number of columns to lookup.

Thanks

 

[lenze]

Like this, maybe

  A        B      C       D        E      
1          Dallas Houston New York Denver 
2 25       5      6       7        8      
3 32       6      6       8        8      
4 44       6      7       7        9      
5 56       7      7       8        8      
6                                         
7                                         
8 32              8                       
9 New York                                
Sheet1
[Table-It] version 09 by Erik Van Geit

RANGE FORMULA 
C8    =INDEX(B2:E5,MATCH(A8,A2:A5,0),MATCH(A9,B1:E1,0))
[Table-It] version 09 by Erik Van Geit

where Ae contains the Paygrade and A9 contains the City
HTH
lenze

 

[Aladin Akyurek]

Is there a way to use the vlookup table for multiple table_arrays?

For instance I want to look up a paygrade (32) but I want to serch through various salary grade tables based on different cities.

I tried =vlookup(32,B10,d2)

32 = salary grade
b10 = a cell reference to the salary table I want it to lookup (I have 7 total) then the d2 is a cell reference to the number of columns to lookup.

Thanks

If B10 houses a name defined to refer to a range with a relevant table and the definition is not done with OFFSET, etc...

=VLOOKUP(32,INDIRECT(B10),D2,1)

assuming that those tables are all sorted in ascending order in the appropriate manner.

 

[jcijames]

Awesome, it worked. Thank you very much!