Look-up

[Dick]

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]

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)

 

[p45cal]

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, ****

Have your master list of groceriy names in column A and the aisle no.
in column B of a sheet renamed 'MasterListSheet', (I used a small list
in range A1:B5) then in your first sheet put this formula in cell B2 (A2
containing the first item in this week's shopping list (A1 containing a
header):
=VLOOKUP(A2,MasterListSheet!$A$1:$B$5,2,FALSE)
You'll need to adjust this to incorporate the whole list on the
MasterListSheet, then copy it down the length of this week's shopping
list.
Then you can sort the result on column B and the time you -enjoy-
accompanying your wife to the store will be blissfully short.

 

[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.

 

[Eduardo]

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