Excel Lookup

[Ebby]

I am looking for a solution for a VLOOKUP problem I am having in
excel.

I have a spreadsheet and in column A I have a list of Item names. In
column B I have a list of prices.

I want to lookup by column A which is item name and fill in the item
price from column B. The lookup for this is simple enough.

However, I have different tabs for each item and I want to write a
lookup on each seperate item tabe to gather the prices. The problem I
am having is that what I lets say my list of items is A-C and each
item has a different price on a different date. So it could look like
this

Item Date Price
A 1/1/10 $1
A 1/2/10 $1
A 1/3/10 $2
B 1/1/10 $3
B 1/2/10 $3
B 1/3/10 $4
C 1/1/10 $2
C 1/2/10 $1
C 1/3/10 $2

Once I write a lookup on the worksheet for item A and then go to write
it to lookup item B on Item B's worksheet, it will fill in item B and
the first listed price of $3 but then list all of item A's prices
again until it reaches the cell value for item B again. How can I
prevent it from pull item A's Cells again without going into the
formula and specifically seting the range to include only item B's
information.

My goal is to write the formula and pull it across all worksheets.

 

[Don Guillett Excel MVP]

I am looking for a solution for a VLOOKUP problem I am having in
excel.

I have a spreadsheet and in column A I have a list of Item names. In
column B I have a list of prices.

I want to lookup by column A which is item name and fill in the item
price from column B. The lookup for this is simple enough.

However, I have different tabs for each item and I want to write a
lookup on each seperate item tabe to gather the prices. The problem I
am having is that what I lets say my list of items is A-C and each
item has a different price on a different date. So it could look like
this

Item  Date            Price
A        1/1/10         $1
A        1/2/10         $1
A        1/3/10         $2
B        1/1/10        $3
B         1/2/10        $3
B         1/3/10        $4
C         1/1/10        $2
C         1/2/10        $1
C         1/3/10        $2

Once I write a lookup on the worksheet for item A and then go to write
it to lookup item B on Item B's worksheet, it will fill in item B and
the first listed price of $3 but then list all of item A's prices
again until it reaches the cell value for item B again. How can I
prevent it from pull item A's Cells again without going into the
formula and specifically seting the range to include only item B's
information.

My goal is to write the formula and pull it across all worksheets.

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."