Version: Office for Mac 2008 (12.2.4)
Formula Cell CR12:
Cell P12 Formula:
=VLOOKUP(M12,'US Model Qty'!E:AD,23,0)
When I change data in the "US Model" sheet, cell P12 is Auto Calculating as expected. However, cell CR12 is holding the old...