Yep.
But knowing when to run the macro may be difficult to determine.
If you only cared about the cell that is used as the lookup value changed, then
you may be able to use the worksheet_change event (if the user typed in the new
value).
But if the table were reformatted, then this event would not fire.
