Tag: lookup
VLOOKUP, HLOOKUP and LOOKUP Functions
If you are planning to step up your proficiency in Excel, you should learn how to use the look up functions. These functions are commonly used on tables that act like a database. While databases have SQL queries, which is challenging especially for non-programmers, Excel has these simple look up functions and the most widely used are VLOOKUP, HLOOKUP and LOOKUP.
Lookup for Product Effort Timesheet
For this problem we received a copy of the workbook. We then used a formula to count the number of 'Product' occurences for each staff member. That count was then transferred to a staff member summary worksheet to report the total counts for all 'Products' across the team. To simplify the formula and the structure of the workbook we also recommended to record all the staff time into one worksheet for the year, rather then a separate worksheet for each month