Search for duplicates in 2 columns, return associated data

[Mr_Nivek]

Hello All,

The best way I can think to describe this is through an example:

In the example below I'd like to search for instances of entries from the first colum (Item Needed) in the second column (Item Ordered). If a match is found I'd like to have the "Item Ordered" and associated "Quantity" and "Unit Price ($)" values returned in the 3 columns following the table.

I appreciate any help I can get. Thank you.

Item Needed	Item Ordered	Quantity	Unit Price ($)
Banana	Apple	2	0.99
Peach	Banana	4	1.00
Pear	Mango	1	1.50
	Pear	2	1.25
	Strawberry	3	0.50

<TBODY>
</TBODY>

 

[NeonRedSharpie]

Assuming your data table begins in A1:

Column E

=IF(MATCH($A2,$B:$B)>0,$A2)

Column F

=IF(MATCH($A2,$B:$B)>0,INDEX($C:$C,MATCH($A2,$B:$B)))

Column G

=IF(MATCH($A2,$B:$B)>0,INDEX($D:$D,MATCH($A2,$B:$B)))