function

%3CLINGO-SUB%20id%3D%22lingo-sub-3116761%22%20slang%3D%22en-US%22%3Efunction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3116761%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20look%20at%20this%20function%20and%20let%20me%20know%20what%20I%20am%20missing%2C%20it%20is%20driving%20me%20crazy.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DVLOOKUP(%22RIGHT(r5%2C1)%2C%24B%243%3A%24k%2412%22%2CMATCH(RIGHT(T5%2C1)%2C%24B%242%3A%24K%242%2C%220%22)%2C0)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3116761%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3116898%22%20slang%3D%22en-US%22%3ERe%3A%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3116898%22%20slang%3D%22en-US%22%3EI%20don't%20know%20what%20you%20are%20missing%20but%20I%20seem%20to%20be%20missing%20a%20LOT%2C%20like%20what%20are%20you%20trying%20to%20do.%20The%20entire%20formula%20seems%20wrong%20on%20many%20levels%20to%20me%20but%20hey%2C%20I've%20learned%20many%20a%20trick%20that%20originally%20looked%20wrong.%20That%20said%20here%20are%20some%20of%20my%20concerns%3A%3CBR%20%2F%3E%22RIGHT(r5%2C1)%2C%24B%243%3A%24k%2412%22%20-why%20is%20this%20is%20%22%22%20is%20that%20really%20the%20TEXT%20you%20are%20looking%20up%3F%3CBR%20%2F%3EMATCH(RIGHT(T5%2C1)%2C%24B%242%3A%24K%242%2C%220%22)%20-%20this%20isn't%20an%20array%20for%20VLOOKUP%20to%20search%20-%20it%20is%20a%20number%20where%20RIGHT(T5%2C1)%20is%20found%20in%20the%20array%20%24B%242%3A%24K%242%2C%20except%20why%20is%20the%20last%20parameter%20%220%22%20in%20%22%22%3F%3CBR%20%2F%3EOften%20one%20uses%20a%20INDEX(%20...%20MATCH%20()%20)%20instead%20of%20a%20VLOOKUP()%20so%20maybe%20you%20are%20getting%20things%20mixed%20up%3F%20Maybe%20consider%20using%20XLOOKUP()%20instead%3F%3C%2FLINGO-BODY%3E
Occasional Visitor

Can someone look at this function and let me know what I am missing, it is driving me crazy. 

 

=VLOOKUP("RIGHT(r5,1),$B$3:$k$12",MATCH(RIGHT(T5,1),$B$2:$K$2,"0"),0)

1 Reply
I don't know what you are missing but I seem to be missing a LOT, like what are you trying to do. The entire formula seems wrong on many levels to me but hey, I've learned many a trick that originally looked wrong. That said here are some of my concerns:
"RIGHT(r5,1),$B$3:$k$12" -why is this is "" is that really the TEXT you are looking up?
MATCH(RIGHT(T5,1),$B$2:$K$2,"0") - this isn't an array for VLOOKUP to search - it is a number where RIGHT(T5,1) is found in the array $B$2:$K$2, except why is the last parameter "0" in ""?
Often one uses a INDEX( ... MATCH () ) instead of a VLOOKUP() so maybe you are getting things mixed up? Maybe consider using XLOOKUP() instead?