Two search category & two search terms

Hello,

I am using excel 2003. I have one excel file & in sheet1 i have lot of data. Data record as per below
column a1 : is header 1 to h1: is header 8
column a2 : application code
column b2 : partno
column c2 : description
column d2 : remark
column e2 : qty

What i require. Actually i required two category & two search terms.
For example: If In first search category if i have select "Header 1" & enter in search term : "02.2115" (applicationcode) & another search category if i have select "Header 3" & enter in search term : "piston" (description), this description anywhere in that particullary field for example first letter start from "piston", or "assly of piston". In that case search those word in anywhere it may be first or second or anyway but within those column only.

If application is 02.2115 & description is piston, then which partno is used?

In search (list box) result i want to display
...applicationcode : " "
...partno : " "
...description : " "
...remark : " "
...qty : " "

If you have any vba programm please confirm.

In view of the above please explain. Hope you will guide me. Thanks.