G
Guest
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?
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?