Look-up return

Giganews Newsgroups
Subject: Look-up return
Posted by:  Mac (sasser…@yahoo.com)
Date: Mon, 13 Oct 2003

I am trying to get multiple returns for an item :
if I try to look up "Apple" and the possibl results beiing
looked up are on another worksheet and want the 2ns column
Col A  Col B
Apple  Juice
Apple  Pie

How do you get it to return Juice in a cell and Pie in
Also, if the data is on more than 1 sheet in a workbook,
how can you look up an item in the entire workbook, not
just sheet 1 or sheet 2?
Thank you!