Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
VLOOKUP, INDEX & MATCH ERROR HELP | Excel Worksheet Functions | |||
Need Help with Index and Match or Vlookup | Excel Worksheet Functions | |||
VLookup or Index Match ? | Excel Worksheet Functions | |||
Vlookup, index, match? | Excel Worksheet Functions |