Lookup with Multiple Criteria
Here is what I need to happen... Below is my spreadsheet.. i am trying to
keep a report that pulls information from this spreadsheet and updates each day with that current days numbers... So on a seperate sheet I want it to list the current days numbers for that cell.. If the date is 01/02/06 then i want the region 1 total errors for that day.. I was thinking something like this. =LOOKUP(Auto!today(),Auto!A:A,Auto!C:C) but that only pulls 1 criteria and is not working.. i need 2 criteria, date and region. Thanks A B C Date Region Total Errors 1/2/2006 Region 1 0 Region 2 683 Region 3 0 Region 4 0 Region 5 376 Region 6 569 Region 8 0 Region 9 145 |
Lookup with Multiple Criteria
I'd put the date on each line and then use that formula from the other thread.
Debra Dalgleish shows some techniques for filling blank cells at: http://contextures.com/xlDataEntry02.html cbanks wrote: Here is what I need to happen... Below is my spreadsheet.. i am trying to keep a report that pulls information from this spreadsheet and updates each day with that current days numbers... So on a seperate sheet I want it to list the current days numbers for that cell.. If the date is 01/02/06 then i want the region 1 total errors for that day.. I was thinking something like this. =LOOKUP(Auto!today(),Auto!A:A,Auto!C:C) but that only pulls 1 criteria and is not working.. i need 2 criteria, date and region. Thanks A B C Date Region Total Errors 1/2/2006 Region 1 0 Region 2 683 Region 3 0 Region 4 0 Region 5 376 Region 6 569 Region 8 0 Region 9 145 -- Dave Peterson |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com