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