Data searching between sheets

[YJL]

I want to make language libruary where I can retrieve all my pas
entries in tow different sheets. When I type keywords into th
self-made searching box, the corresponding results will show up. (No
excel built-in search function Ctr-F please!!!! )

Anybody out there can give me direction where should I get started??

Please Help!!!

Thank

 

[pameluh]

Eeek.... Try a vlookup

 

[Norman Jones]

Hi YJL,

See responses in Programming and Excel.