J
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
=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