Hi
I'm using the following formula:
=INDEX('Database - Product.xlsx'!Table1[New Link Code],MATCH(LEFT([Prescribed Item],15),(LEFT('Database - Product.xlsx'!Table1[Product],15)),0))
to retrieve a number based on a match.
The result shows a #value error and, obviously, I can use iferror to remove this; however, when I query the formula using the fx button, it shows the result as being correct (ie it returns 1000014, which is the desired response).
What I don't know is why it's showing the correct result using the formula query box and an error in the actual worksheet.
Can anyone help?
Bookmarks