Excel Functions & Formulas
How to Use VLOOKUP with CHOOSE Function in Excel
Learn how to use the VLOOKUP with CHOOSE function in Excel to handle single, multiple, and complex lookup criteria efficiently.
Read article
Author & Spreadsheet Consultant
Atkeya Fariha
29 Articles PublishedPublishing since
Atkeya Fariha specializes in data management, analysis, formulas, automation, and integration. She has contributed to research, creative projects, and worked as a data analyst. She is passionate about data analysis, finance management, and project management using spreadsheets.
Editorial Review
Articles Published by Atkeya Fariha
Articles by Atkeya Fariha are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel Functions & Formulas
How to Vlookup Multiple Values in One Cell in Excel (5 Examples)
Learn how to VLOOKUP multiple values in one cell using TEXTJOIN, FILTER, UNIQUE, and VBA codes—both with and without duplicates.
Read article
Excel Functions & Formulas
How to Vlookup with Multiple Criteria in Different Excel Sheets
Learn how to VLOOKUP with multiple criteria across different Excel sheets using INDEX-MATCH, XLOOKUP, and FILTER functions.
Read article
Excel Functions & Formulas
How to Vlookup and Return Second Match in Excel (2 Easy Ways)
Learn how to VLOOKUP the second match value in Excel with or without a helper column using advanced formulas like INDEX, SMALL, and FILTER.
Read article
Excel Functions & Formulas
How to Vlookup to Return All Matches in Excel (4 Suitable Ways)
Learn how to use VLOOKUP in Excel to return all matches, with methods like FILTER, Advanced Filter, and Power Query tools.
Read article
Excel Functions & Formulas
How to Combine VLOOKUP with COUNTIF in Excel (2 Examples)
Learn how to combine VLOOKUP with COUNTIF in Excel to count occurrences accurately using absolute references for better results.
Read article
Google Sheets Functions
How to Count Cells with Specific Text in Google Sheets
Learn how to count cells with specific text in Google Sheets using COUNTIF, case-sensitive formulas, multiple criteria, FILTER & REGEXMATCH.
Read article
Google Sheets Formulas
How to Round to Nearest 5 in Google Sheets (6 Easy Ways)
Learn how to round to the nearest 5 in Google Sheets using MROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, and tips for handling negatives.
Read article
Excel Pro Tips
How to Sort Tabs in Excel (3 Suitable Methods)
Learn how to sort tabs in Excel by drag-and-drop, VBA, or alphabetically in A-Z or Z-A order, while keeping specific sheets in place.
Read article
Excel Pro Tips
How to Sort Alphabetically in Excel & Keep Rows Together
Learn how to sort alphabetically in Excel while keeping rows together using the Sort tool, SORT function or filters for proper organization.
Read article
Excel Pro Tips
How to Return 0 If Cells are Blank in Excel (3 Useful Formulas)
Learn how to return 0 if cells are blank in Excel using IF, ISBLANK, Go To Special, or Find & Replace for quick data cleanup.
Read article
Excel Pro Tips
How to Convert Number to Words in Excel for Peso (2 Ways)
Learn how to convert numbers to words in Excel for Peso using VBA macro code, along with essential formatting tips for accurate results.
Read article