Aug 21 2022 11:23 AM
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.
Aug 21 2022 11:53 AM
Could you please give more details - if not sample file when screenshot with formula.
Aug 21 2022 03:09 PM
@Sergei Baklan Here is a screenshot
Aug 22 2022 12:54 PM
In general such formula works
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.