I've recently learned how to use the INDEX MATCH function but have a problem. I've put together a lookup using INDEX MATCH that works fine in most workbooks but won't work in a workbook provided by a Local Authority unless I copy and paste the text from the workbook where I keep the original INDEX MATCH example into the Local Authority workbook.
I've tried using format painter to try and match the formatting of the 2 workbooks but to no avail....HELP!!
Bookmarks