Finding an Excel value using one repeating & another value?

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

Guest

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top