i need formula for search the data

[Abhijeet]

Hi
I have data in excel i want search the numbers in that data if found then give me that row data.in attach file expected result i saved

 

[vrunda]

See the file , Hope it suits u. Like if it is what u were looking for.

 

[vrunda]

find the file

 

[Abhijeet]

Hi Vrunda more than 1 numbers found that data alos i want

 

[Abhijeet]

Please tell me Vlookup give multiple values

 

[Abhijeet]

No if i copy paste formula then not work please upload file

 

[vrunda]

Pivot table can give u d result but not in the format u require. For ur specified format i shall try

 

[Abhijeet]

I need the result not format if u can try in Pivot table no problem

 

[vrunda]

see file attached

 

[vrunda]

sheet 5 contain pivot table too & sheet 1(2) contains formula. use iferror formula so as to not get the #NA

 

[vrunda]

same file uploaded with headings

 

[Abhijeet]

Thanks i get idea from ur Pivot table trick

 

[vrunda]

You can also use formula as in sheet1(2)-- yellow colored