Look up 2 coloumn and retunr the multiple values

**kiranmayi16** · 01-31-2014, 01:26 PM

Hi There,

Please find attached my spreadsheet. I want the excel to look at j2.. search for it in A coloumn and return its corresponding B coloumn values. There might me multiple values with the same name in A2. I would like the excel to return all the multiple values with their corresponding B coloumn values.

Please help.

Thanks

**AL1976** · 01-31-2014, 02:10 PM

hi, can this help => http://answers.microsoft.com/en-us/o...3-874ed3097db3 ?
AL

**kiranmayi16** · 01-31-2014, 02:29 PM

Hi , Can you please tell me in which sheet should I be posting this formula.

=INDEX(Sheet2!$B$1:$B$10,LARGE((Sheet2!$A$1:$A$10=$D$1)*ROW(Sheet2!$A$1:$A$10),COUNTIF(Sheet2!$A$1:$A$10,$D$1)+1-COLUMN(A1)))

Thankyou.