How do I search excel spreadsheets using multiple search criteria.
Hi!
One way:
Entered as an array using the key combo of CTRL,SHIFT,ENTER:
=INDEX(C1:C10,MATCH(1,(A1:A10="employee_name")*(B1 :B10=some_date),0))
C1:C10 is the range in which the data you want to extract is found.
Better to use cells to hold the criteria:
D1 = Bob Jones
E1 = 12/12/2005
=INDEX(C1:C10,MATCH(1,(A1:A10=D1)*(B1:B10=E1),0))
Biff
"Kasper" wrote in message
...
I am trying to extract data from a spreadsheet using a search function that
has two search criteria. For example, I have a worksheet filled with
employee performance data and need to extract data to a table based
employee
name AND date. Something similar to VLOOKUP but with two filters instead
of
one.
|