Ah. That does require a Worksheet_Change() macro.

In article ,
"CarlosAntenna" wrote:

The lot numbers do indeed exist on the _lookup table_. Where I don't want a
column for lot numbers is on the other sheet where I am entering other data.
I want to type a lot number in the thickness column on this second sheet and
have the thickness returned from the lookup table.