ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Index - Match - Vlookup Error (https://www.excelbanter.com/excel-programming/426627-index-match-vlookup-error.html)

lee

Index - Match - Vlookup Error
 
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


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com