Help in - Excel Search Engine..

[JawaharPrem]

Hi All,

I Enclosed sample excel file for reference.
Requirment - in enclosed file coloum -"E" -"Unique Name". i need to get the entire data if i search given unique name, search data to list in sheet2, master data in sheet1, Please help in same.

Thanks
Jawahar Prem

 

[Hui]

If you select any cell on Sheet1
Press Ctrl+T


Click Ok

Now select the Drop Down in Column E


Unselect All

Then select the Name you want

 

[JawaharPrem]

Hi Hui,

thanks for your time, is there is any way to creat like userform by enter the company name to fetch the data we required, "like *" as we use in DB is their is way..

Thanks
Jawahar Prem

 

[Hui]

Can you please explain what result you want?

 

[JawaharPrem]

Hi sir,
I Required like enclosed file.
example :- there is company nane in e coloum "LINDSTROM SERVICES INDIA PVT LTD", if enter the name like "lindastore service" i need to fetch the data for "LINDSTROM SERVICES INDIA PVT LTD", in data sheet, if it is possible.

thanks
Jawahar Prem

 

[JawaharPrem]

Hi Sir,

I have worked in "Search and vlookup formula" forbasic search engine, Please check and need your guide if any changes to be done better..

Thanks
Jawahar Prem

 

[JawaharPrem]

Hi Sir,

it is possible with VBA Userform, Please help on same.

 

[JawaharPrem]

Hi,

someone please help on same.

Thanks
Jawahar Prem