Index - Match - Vlookup Error

L

Lee

This Works Correctly
=INDEX(RATE_YR1_GS,MATCH(B8,LAB_CAT_NUM_GS,0),MATCH
(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_CAT_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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return BLANK is cell value sought is blank 13
End process at last row of data 3
Formula Array Help in VBA 3
MATCH and INDEX combination using multiple criteria? 3
excel formula is returning incorrect values 0
Offset, Match Questiond 7
sun results of a vlookup across a range 3
Copy Array to Array, how to and should I? 13

Top