vlookup with 2nd value

[niladri20052006]

Hi All,

Between two sheets I am doing vlookup in column B in the second sheet. In the sheet1 I have the company name and full name column. But here the company is multiple means I have the same company names 2 times or 3 times where the full Name is different For example

Company Name Full Name
Cisco Systems Matthew Roger
Cisco Systems Samuel Das

In the sheet2 I have the company names but here all the company names with no full name column like

Cisco Systems in B2 of sheet2 I am applying vlookup formula (=VLOOKUP(A2,'Sheet1'!$A$2:$B$4076,2,0) but it gives me the name of Matthew Roger. But I want the name of Samuel Das.

Is there any way to do that?

Thanks in advance!!

 

[hurgadion]

Hi,
let Your Data be in Two Columns A:B, exactly in A1:B3. This array Formula (Ctrl+Shift+Enter) can help You (in D1, D2):

  =INDEX($B$1:$B$3,SMALL(IF($A$1:$A$3="Cisco Systems",ROW($B$1:$B$3),""),ROW()))

Best regards.

 

[Excell_Wannabe]

Do you only want Sam to show up or do you want Matt to show up too? If you want them both to show up, a pivot table may be a good option for you.

Hi All,

Between two sheets I am doing vlookup in column B in the second sheet. In the sheet1 I have the company name and full name column. But here the company is multiple means I have the same company names 2 times or 3 times where the full Name is different For example

Company Name Full Name
Cisco Systems Matthew Roger
Cisco Systems Samuel Das

In the sheet2 I have the company names but here all the company names with no full name column like

Cisco Systems in B2 of sheet2 I am applying vlookup formula (=VLOOKUP(A2,'Sheet1'!$A$2:$B$4076,2,0) but it gives me the name of Matthew Roger. But I want the name of Samuel Das.

Is there any way to do that?

Thanks in advance!!