Excel LOOKUP formula problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1946984%22%20slang%3D%22zh-CN%22%3EExcel%20LOOKUP%20formula%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1946984%22%20slang%3D%22zh-CN%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20used%20lookup%20to%20calculator%20formula%20my%2C%20but%20now%20has%20one%20problem.%3C%2FP%3E%3CP%3EMy%20formula%20is%20LOOKUP%20(K4%2C%20%22HH%22%2C%20%22H%22%2C%20%22M%22%2C%20%22L%22%2C%20s64%2C%2032%2C%208%2C%201)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20I%20type%20%22HH%22%20and%20L%20word%20always%20show%20number%2032%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20HH%20and%20L%20does't%20equal%20to%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1946984%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

 

I'm used lookup to calculator my formula, but now has one problem.

My formula is  LOOKUP(K4,{"HH","H","M","L"},{64,32,8,1})

 

but when I type "HH" and L word always show number 32

 

why HH and L does't equal to 

0 Replies