INDEX MATCH #REF error

Copper Contributor

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