how do I search by more than one criteria in excel?

V

vulcan88

I have a spread sheet that has various fields like name of person taking
call, name of person calling in, their account number, their order number
etc. I would like to be able to have a search function in Excel to look up
by more than one of these criteria, like order number and name of person
calling in - or any combination I might want without being case specific. I
would like to pull up as many possiblilties as possible but limited to the
criteria put in to search by.
 
F

Fredrik Wahlgren

vulcan88 said:
I have a spread sheet that has various fields like name of person taking
call, name of person calling in, their account number, their order number
etc. I would like to be able to have a search function in Excel to look up
by more than one of these criteria, like order number and name of person
calling in - or any combination I might want without being case specific. I
would like to pull up as many possiblilties as possible but limited to the
criteria put in to search by.
Click to expand...

It seems you need to define these fields as a database.

/Fredrik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Macro for search tool with multiple entries 2
Bugs in Office 2019 0
Using lookup functions for Order Sheet 1
Sumproduct with more than one valid criteria 1
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Need a proper guru! My head hurts ;( 1
How do I filter data by more than one column in excel 0

Top