I'm trying to get two files set up to use VLOOKUP to find matches. But, neither workbook will "accept" any kind of formula. When I write in the fomula and hit enter, the formula itself shows in the cell (it takes no action).
Automatic Calculation is on.
Both files are imported: one as XL, the other as text, converted to XL. I've also tried saving both files as XL, then trying the formula on the saved files without success.
What am I / have I done wrong?
P.S. Even a simple "if" formula doesn't get acted on.
Automatic Calculation is on.
Both files are imported: one as XL, the other as text, converted to XL. I've also tried saving both files as XL, then trying the formula on the saved files without success.
What am I / have I done wrong?
P.S. Even a simple "if" formula doesn't get acted on.