Finding an Excel value using one repeating & another value?
 

The worksheet lists card numbers in one column and text codes and package
labels in other columns. Some card numbers repeat due to different
codes/labels but remain in ascending order. The text columns are in random
order and some also repeat for other card numbers, but there is no
duplication of the same three values.

The task is finding a text code using a card number and a text label. See
simplified worksheet layout . . .
Cards Package Code
1145 BC02A BCAA
1250 BC01X BCAS
1250 BC07A BCAR
1250 BC07F BCDR
1300 BC01X BCAA
What formula can look up card 1250 in package BC07A and provide the code BCAR?

With your sample data in cells A2:C6, the desired Card# in A9, and the
desired Package code in B9, use this array formula (press Ctrl-Shift-Enter to
commit it)

=INDEX(C2:C6,MATCH(A9&B9,A2:A6&B2:B6,0))


"Joe R." wrote:

The worksheet lists card numbers in one column and text codes and package
labels in other columns. Some card numbers repeat due to different
codes/labels but remain in ascending order. The text columns are in random
order and some also repeat for other card numbers, but there is no
duplication of the same three values.

The task is finding a text code using a card number and a text label. See
simplified worksheet layout . . .
Cards Package Code
1145 BC02A BCAA
1250 BC01X BCAS
1250 BC07A BCAR
1250 BC07F BCDR
1300 BC01X BCAA
What formula can look up card 1250 in package BC07A and provide the code BCAR?