This Works Correctly
=INDEX(RATE_YR1_GS,MATCH(B8,LAB_CAT_NUM_GS,0),MATC H
(A8,COMP_NAME_GS,0)

I'm attempting to modify the formula to swap out range names of arrays

This Returns #VALUE
=INDEX(VLOOKUP(J2,RATE_MAP,2,FALSE),MATCH(B8,LAB_C AT_NUM_GS,0),MATCH(A8,COMP_NAME_GS,0)

I'm attempting to do a lookup to return the correct range name of the array.
The Lookup is returning "RATE_YR1_GS"

Below is the RATE_MAP Table (I entered "1" in cell J2)

A B C

1 RATE_YR1_GS RATE_YR1_CS
2 RATE_YR2_GS RATE_YR2_CS
3 RATE_YR3_GS RATE_YR3_CS

It appears that it is looking up correctly, but there apparently is
something about the combination of index, match, and vlookup I don't
understand.

Any help will be appreciated. Thanks!

--
Lee