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

Hi,
let' say you have in worksheet2 column A the name of the products and in
column B the Aisle
then in worksheet1 in column A you type the product name and in B enter

=VLOOKUP(A1,Sheet2!$A$1:$B$100,2,FALSE)



"Dick" wrote:

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

Eduardo......thanks very much. This works perfectly. I knew it had to be
somewhat easy. All in knowing what you are doing. I will be an old hero.
Have a great day.
--
Thanks, DICK


"Eduardo" wrote:

Hi,
let' say you have in worksheet2 column A the name of the products and in
column B the Aisle
then in worksheet1 in column A you type the product name and in B enter

=VLOOKUP(A1,Sheet2!$A$1:$B$100,2,FALSE)



"Dick" wrote:

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

Hi Dick, thanks for the feedback, I'm glad it worked

"Dick" wrote:

Eduardo......thanks very much. This works perfectly. I knew it had to be
somewhat easy. All in knowing what you are doing. I will be an old hero.
Have a great day.
--
Thanks, DICK


"Eduardo" wrote:

Hi,
let' say you have in worksheet2 column A the name of the products and in
column B the Aisle
then in worksheet1 in column A you type the product name and in B enter

=VLOOKUP(A1,Sheet2!$A$1:$B$100,2,FALSE)



"Dick" wrote:

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