🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Using Index & Match as a Substitute for Vlookup

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 Answer

365 Team

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.