Lookup function Question Help!

[Jennifer Waterhouse]

I'm trying to perform a lookup function

=LOOKUP(H8,sheet2!A:A,sheet2!C:C)

This formula only returns the first item of a list of items matching the
number in A:A (there could be more than 10 under the catalogue number in
A:A. I've made a list in B:B (1,2,3 etc.) for each of the catalogue numbers
in A:A

How would I augment B:B into the formula to coincide with the number in the
"B" column? (Be it 1, 2, 3 etc.)

EX.

A B C
2214 1 Red
2214 2 Green
2214 3 Brown

When I enter (2214) into H8 and I want the third item 'BROWN' to show in my
cell, what would be the formula?
Also, if there is no "3" then the cell should be left blank.

Thank you in advance

 

[Max]

See responses in microsoft.public.excel
Please do not multi-post ..

 

[Jennifer Waterhouse]

Point well taken.
Thank-you for the help, Max

Jen

 

[Max]

Point well taken.
Thank-you for the help, Max

Jen

You're welcome, Jen !