Using Index & Match as a Substitute for Vlookup
In this video you have used the formula :
=INDEX('1.1 FY2016'!B$5:E$61,MATCH('2.1 Database'!$B5,'1.1 FY2016'!$B$5:$B$61,0))
But when I was using the exact same formula, I got an error "REF". Then I just placed a comma(,) before the last bracket and it worked. Can you explain why this is happenning?
My formula:
=INDEX('1.1 FY2016'!B$5:E$61,MATCH('2.1 Database'!$B5,'1.1 FY2016'!$B$5:$B$61,0),)
1 answers ( 0 marked as helpful)
Hi Srajan!
This is very strange.
It is the first time I have heard of this fix.
Could you share your file with me, please?
My email is nedko@365datascience.com.
Thanks!
Submit an answer
