On Sunday, August 7, 2016 at 1:17:33 AM UTC-7, Claus Busch wrote:
Hi Howard,

Am Sun, 7 Aug 2016 00:58:10 -0700 (PDT) schrieb L. Howard:

They are VLOOKUP, but I don't have the exact formulas.

try it with the Worksheet_Change event and refer to the cell that do a
changing in the value of the formula.
Better help when I know the formula and the sheets layout.


Regards
Claus B.
--

Hi Claus,

Indeed. That appears to be the case, and the cell is one column removed from the formula. Turns out no VLOOKUP but a long, long IF/OR formula. I am using a VLOOKUP and referring to the lookup_value cell (where the change takes place)and that looks to be doing the trick.

Sorry, should have had more info before posting.

Thanks.

Howard