I saw the post for mulitple lookups that applies to Excel 2003
http://office.microsoft.com/en-us/ex...260381033.aspx

but I can't seem to get it to work for the 2002 version of Excel. Please
advise.

Here is what I have.

A B
1 Product ID
2 Ice-cream 234
3 Coffee 334
4 TEA 434
5 Milk 534
6 OJ 634
7 TEA 734
8 TEA 834

I want to be able to look up product tea. and have return value 434,734,834.
on sepearate rows. I tried the following forumala that was recommeded from
the above link, but get #Value error. What am I doing wrong? Does this not
work because I have Excel 2002, how do I get this to work?

=INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1 :$A$7)),ROW(1:1)),2)