I am working in Excel 2010 on a 97-03 workbook which was sent to me after being exported from SalesForce. I added a column in the original sheet to look up values I entered in a second sheet (added by me).
My formula appears to be correct when checking it with the function builder tool.
I checked that the "show formulas" command was not on by toggling it on and off. No matter what I do, I can't see to make the formula actually calculate.
Both the "search for" values and the 1st column of the array to search are formatted the same - as text. The 1st column of the array to search is sorted A-Z.
What would make the formula simply display in the cell rather than calculate? I saved the workbook as a .xlsx and no difference.