![]() |
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