INDEX MATCH #REF error

%3CLINGO-SUB%20id%3D%22lingo-sub-1630602%22%20slang%3D%22en-US%22%3EINDEX%20MATCH%20%23REF%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1630602%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20guys%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20a%20newbie%20and%20searched%20for%20an%20answer%20but%20could%20not%20find%20anything%20-%20so%20I%20am%20doing%20an%20index%20match%20function%20and%20something%20seems%20to%20be%20wrong%20with%20the%20formula.%20Whenever%20I%20try%20to%20%22re-calculate%22%20it%20by%20pressing%20enter%2C%20a%20%23REF%20error%20appears.%20It%20also%20appears%20when%20I%20try%20to%20change%20the%20last%20part%20*%24F34%20to%20*%24E34%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DINDEX(Lookups!%24C%2489%3A%24C%2494%3BMATCH(Input!%24L34%3BLookups!%24B%2489%3A%24B%2494%3B0))*%24F34%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1630602%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20formula%20doesn't%20work%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20formula%20help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eexcel%20issue%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi guys,

I am a newbie and searched for an answer but could not find anything - so I am doing an index match function and something seems to be wrong with the formula. Whenever I try to "re-calculate" it by pressing enter, a #REF error appears. It also appears when I try to change the last part *$F34 to *$E34

 

=INDEX(Lookups!$C$89:$C$94;MATCH(Input!$L34;Lookups!$B$89:$B$94;0))*$F34

 

Thanks in advance for your help! 

0 Replies