OK.....I'm retired with too much time on my hands. Trying to help the wife.
She has made a list of products and aisle numbers in the local grocery. She
wants to create a weekly shopping list in Excel on Worksheet 1 in column "A".
As she creates this new shopping list, she wants her location (aisle number)
to appear in column "B" next to her item name. Is there a way to create a
master location table (for example on Worksheet 2) and have the location
automatically appear next to her new shopping list items? She thinks if she
has the aisle numbers next to her new shopping list items, she could group
them together and simply walk down the aisles to do her shopping.

Thanks, DICK