How do I search excel spreadsheets using multiple search criteria.
To give a little more info:
Table is in the range A3:U17 (will gain another row daily)
Criteria 1 (date) is in column B
Criteria 2 (agent name) is in column E.
I need a function that given Agent X on Date Y it will retrieve the data Z
from the appropriate row.
"Kasper" wrote:
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.
|