Vlookup Problem

[omsrisai]

Hi,


Generally if we use vlookup function,it will pull only the first data if we have same data that appears multiple times.


Eg Check

123 1

231 2

123 34

1456 45

456 10


If we vlookup for 123,it will pull only 1 and it will not show 34.is there anyway to pull both 1 and 34 that is related to 123

 

[NARAYANK991]

Hi ,


The following link gives all the information you need :


http://www.get-digital-help.com/2009/10/25/how-to-return-multiple-values-using-vlookup-in-excel/


Narayan

 

[Faseeh]

Hi omsrisai,


Welcome to the forums! How would you like to place the result of the search? In two separate cells?


Regards,

Faseeh

 

[omsrisai]

Narayank,thanks for the link.


Faseeh, i want the data to be 123 it should show up 1 and 34 vertically.

 

[srinidhi]

you are looking for a single value, you can use the above link, best thing is to put a Pivot table, it will give you the under 123 - 1 as well as 34

 

[omsrisai]

Faseeh and Srinidhi,thanks for your replies


Srinidhi,i can do it if it for single data,i can do a pivot table but if i have more data,it will not help i think.


I have attached a sample workbook,that i can get clear help from the team.

The link is below :

https://docs.google.com/spreadsheet/ccc?key=0AjXb5cpFVliGdFNaV01kWkZlbEltS2xKaFVoT3hsUHc


My requirement is i need to do vlookup for the data in column B with data in column D & E and get all the agr.id that is available respectively for the data(column B) to column C.

 

[Faseeh]

Hi omsrisai,


Have a look at this:


http://dl.dropbox.com/u/60644346/Sample%20Workbook_myworkout.xls


The formula in Column C counts for how many times a number has been repeated up to a certain row. Then the adjacent formula looks for all values in Column that are equivalent to a one in B and gets X-Smallest value from it. Thus it gets 1st, 2nd .....so on smallest values. In case there is none it will give you Error.


Regards,

Faseeh

 

[omsrisai]

Faseeh,


Thanks for the reply and i will try it out and hope it works fine for me.

If i have any questions,will come back to you.

Sorry for the delay in replying back to you.