Google Docs - Help with Lookup/Match Formula
I have several spreadsheets on Google Drive. I want this formula to reference another spreadsheet which I will call June2013. It has multiple tabs that will need to be referenced but I assume I can just repeat the formula because the result I am looking for is a count. The formula will need to check column M on each of these sheets. Each row has a 16 digit job number. These rows are also updated daily. I need the formula to then reference each job number back to another sheet on a separate spreadsheet. It will then find the match. When it finds the match, I will need it to check column L and see what name is there. There are 4 employees that it could be and there names can be relayed as B1, C1, D1 and E1. Then I need it to check one more thing in column K. If column K on that row says "yes' I need it to return a value of 1 to cell B12, C12, D12 or E12 depending on the employee. Obviously this formula will be copied across 4 columns. If it says "no" I need it to return a value of 1 to the same columns but in row 13. Again, I understand that this will be a separate formula copied across columns B-E. I am sorry if this is hard to understand. I wanted to make a sample grid but I really don't know where to start. Any help will be appreciated. Thanks in advance.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1