Help auto-filling data from one sheet into another.

For column B this would be =LOOKUP($A,Table 1 :: $A,Table 1 :: B)
Replace "Table 1" with the name of your statistics table, of course.
Copy/Paste or Drag/Fill to the rest of the table.

You're welcome.

I'm having pretty much this same issue, but the solution is not working for me. I have a grocery list table with columns "Item" and "Price". I have a separate sheet with a table with a comprehensive list of Items and Prices.
I want to be able to type in the item name in my grocery list, and it automatically fill in the price.
Using the formula editor, I typed in

=LOOKUP($Item,Store :: $Item,Store :: Price)

It keeps telling me "LOOKUP couldn't find requested value"
I can't seem to find where I'm going wrong. Anyone have an idea?

I also have a related question...
What I would really like to happen is to have a drop down option for the Item category in the Grocery list table that automatically populates with the Item category from the store list. Is there a way to do this?

haysfour wrote:
I'm having pretty much this same issue, but the solution is not working for me. I have a grocery list table with columns "Item" and "Price". I have a separate sheet with a table with a comprehensive list of Items and Prices.
I want to be able to type in the item name in my grocery list, and it automatically fill in the price.
Using the formula editor, I typed in

=LOOKUP($Item,Store :: $Item,Store :: Price)

It keeps telling me "LOOKUP couldn't find requested value"
I can't seem to find where I'm going wrong. Anyone have an idea?

LOOKUP returns the value corresponding to the largest value in search range that is equal to or less than the search value. For text values, "largest" is determined by alphabetical order. All number values are greater than any text value.

The only ways I was able to reproduce the error you mentioned were by leaving the search value cell empty, by entering a value that was less than any value in the search range (search for "allspice" where the smallest value in search range was "basil"), or by entering a numerical value when there were no numbers in search range.

Your formula looks correct, assuming the result cell is on the same table as you enter the search value and both search range and result range are on the Table "Store".

I also have a related question...
What I would really like to happen is to have a drop down option for the Item category in the Grocery list table that automatically populates with the Item category from the store list. Is there a way to do this?

No.

Popup menus are constructed manually. Once constructed, they can be copied and pasted.

You might consider attacking the problem from the other direction, though. Add a column of checkboxes to the Store list, and use the checked items to build a shopping list in a second table.

The technique is described in this thread. A search of the Numbers '09 forum usiong "65537" will bring up other, similar threads.

Regards,
Barry

THANK YOU! I'm definitely a complete idiot sometimes. I hadn't typed a value in the target cell.
And thanks for the checkbox idea. I'll have to check that out.