I'm using the INDEX/MATCH combination in a large number of rows in a worksheet tab to locate a cell value in another tab in the same worksheet and return the contents of another column in that second worksheet.
Whilst this works fine for the majority of rows, I've discovered that a handful do not work - the cells show "#N/A". Those that don't work are all looking for cells which begin with "1/" (ignore the quotation marks).
Can anyone help with why this would be the case?
