how do I search by more than one criteria in excel?
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.
|