Two search category & two search terms

[avk]

Hello friend

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

Right now i have search only one base category & one search terms. i.e. search category : select header3 & search term : piston.


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).
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 : " "

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

I have sample attach file

[rbrhodes]

Hi avk,

So you're searching using 'Find'?

[avk]

Yes. I searching using find.

As per attach file presently i m searching only one selecting category & one terms.

Actually i want searching two selecting category & two terms.

[rbrhodes]

Hi avk,

Well I should have looked at your example I guess. You have a Userform with code written by Lieth Ross!

I'm sorry but this isn't simply a question (and if it was simply a question it's not a simple question!) it's a project.