Forum Discussion
INDEX ISSUE,
INDEX ISSUE,, EXACT SAME FORMULA IN CELL C42 REFERENCING, BUT THIS ONE IS NOT WORKING, DATA CORRECT ON PRICE LIST REFERENCE, ALL SET TO GENERAL, NO TRAILING SPACES. IM STUMPED, TRIED USING XLOOKUP A...
General formatting is not as important as does Excel read the data as a number or text?
e.g. "50" is not the same as 50.
If you're able to post a snip of this menu (w/ your formula active, it would reveal the source of the problem: