Hi. I need a formula that will look up data based on matching 2 criteria. The first criteria is client name and the 2nd is month. The list of data has specific dates, but the look up will just be the name of the month and year, so all dates from that month and year will be returned.
Lookup Values
(sheet2!G8) = Client Name
(sheet2!C14) = Month
Data Ranges
(sheet4!A:A) = List of client names
(sheet4!B:B) = List of dates
I have attached a sample....results are returned to sheet4, I have labeled sheet 4 with the cells that are lookup and each cell where i need formula.
Bookmarks