Forum Discussion
snwoko
Sep 03, 2020Copper Contributor
INDEX MATCH #REF error
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!
No RepliesBe the first to reply