Find a Match, Copy a Cell

[Corzbb10]

I am trying to find a formula for the following situation:

I have two separate lists of numbers associated with a price. The numbers in both lists have the same prices but one list has a description associated with it. There are also the same number with difference prices and difference descriptions.

I need to find a way to add the description from one list to the list without a description.

I have attached a sample workbook.Sample Workbook.xlsx

[AlKey]

Enter this formula in H3 and copy down

=IFERROR(INDEX($C$3:$C$17,INDEX(MATCH(F3&G3,$A$3:$A$17&$B$3:$B$17,0),0)),"")

[Tony Valko]

Range concatenation is inefficient especially on large data sets.

Try this array formula** entered in H3 and copied down:

=IFERROR(INDEX(C$3:C$17,MATCH(1,(A$3:A$17=F3)*(B$3:B$17=G3),0)),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[Corzbb10]

Some of the descriptions in column C are different descriptions even though the number in Column A/F and price in Column B/G may be the same. Is there a way to capture the different descriptions.

So there may be multiple Number 1s with a price of $0 but a different description for each Number 1.

[Tony Valko]

How about updating the sample file with the results you expect.