Sep 03 2020 01:58 AM - last edited on Feb 06 2023 07:14 AM by Allen
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!