๐ 2024-07-16 โ Session: Enhanced Excel and Google Sheets Formulas
๐ 19:30โ20:10
๐ท๏ธ Labels: Excel, Google Sheets, VLOOKUP, Data Validation, Formulas
๐ Project: Dev
โญ Priority: MEDIUM
Session Goal
The session aimed to enhance data retrieval and validation techniques using Excel and Google Sheets formulas.
Key Activities
- VLOOKUP with IF Statement in Excel: Developed a method to retrieve data based on student IDs using VLOOKUP combined with IF statements.
- Troubleshooting VLOOKUP Column Index: Identified and corrected issues with the column index and data range in Excelโs VLOOKUP function.
- IFERROR with VLOOKUP in Google Sheets: Implemented error handling in Google Sheets using IFERROR to manage unmatched data scenarios.
- Formula for Exam Grade Approval: Created a Google Sheets formula to evaluate and approve exam grades based on specific criteria.
- Excel Formula Modification for Numeric Comparison: Adjusted Excel formulas to ensure numeric comparisons are accurately performed using ISNUMBER.
Achievements
- Successfully developed and tested multiple formulas in both Excel and Google Sheets to enhance data processing capabilities.
Pending Tasks
- Further testing of the formulas in larger datasets to ensure robustness.
- Documentation of the new formulas for future reference.
Tags
Excel, Google Sheets, VLOOKUP, IFERROR, Data Validation, Formulas