Every time I try to use the INDEX and MATCH feature I get a #REF error.

New Contributor

Every time I try to use the INDEX and MATCH feature I get a #REF error.  I am working on a very big document.  Even if I create a new table, from scratch and try to Index/Match something I get that error.

3 Replies

@colynv 

Could you please give more details - if not sample file when screenshot with formula.

@colynv 

In general such formula works

image.png

Perhaps you have conflict with some other names in your workbook. It's suspicious that "Index" is in low case in formula bar. At least you have sheet Index, but that shall not affect. Maybe something else.