Ankesh
@StackAndGrow
Followers
0
Following
0
Media
16
Statuses
39
📊 Building skills, one step at a time. Currently learning data analytics and sharing my journey. 💡 #DataAnalyst #SkillBuilding #CareerGrowth
Joined April 2025
Reflection:.Mastering advanced VLOOKUP feels like unlocking a toolkit for practical problem-solving. I’m starting to see how powerful and flexible Excel can truly be. Excited for Day 6. #Excel #DataAnalytics #VLOOKUP #100DaysOfData #ExcelSkills.
0
0
0
📰 VLOOKUP in Multiple Sheets .Fetching data from two different sheets
1
0
0
📂 VLOOKUP in Multiple Tables.Across multiple tables that reside on different sheets.
1
0
0
🔄 Double VLOOKUP.Fetching data from two different tables that reside within the same sheet.
1
0
0
📋Lookup All Data of Same Lookup Value.Extracting every single record that contains the specified lookup value in the designated column, along with all the associated data in the other columns of those matching rows.
1
0
0
🔁 VLOOKUP with Multiple Lookup Values.Created a helper column combining multiple fields (e.g., Name & ID) to enable lookup with multiple values.
1
0
0
⚙️Dynamic VLOOKUP.Created a formula where the column index updates automatically based on a Item ID. Used IFERROR(VLOOKUP(. ), "Not Found") to handle it gracefully. • # N/A appears when no match is found.Used Automatic Column Index .
1
0
0
📈 Range Lookup with VLOOKUP.When using TRUE (approximate), VLOOKUP finds the largest value less than or equal to the lookup value. Great for use cases like:.• Grading systems.• Tax slabs.• Salary brackets.
1
0
0
🔍 Exact Match vs Approximate Match.Use the 4th argument in VLOOKUP:.FALSE → Exact match.TRUE → Approximate match
1
0
0
Day 5 of Learning Excel for Data Analysis.Today I dived deeper into VLOOKUP and explored some advanced techniques that unlock next-level lookup power. Here’s everything I learned today:.#Excel #DataAnalytics #100DaysOfData.
1
0
0
Reflection:.VLOOKUP is a powerful time-saver, when used correctly. Today’s practice helped me not only understand its potential, but also avoid common pitfalls. Looking forward to exploring INDEX-MATCH and XLOOKUP in upcoming days!. #VLOOKUP #100DaysOfData #ExcelForDataAnalysis.
0
0
0
⚠️ Common VLOOKUP Mistakes I Noticed:.Not fixing the range → causes incorrect results when dragging.Looking up from the wrong column.Forgetting that VLOOKUP can only look right, not left.Using approximate match instead of exact (FALSE as 4th argument).
1
0
0
Checking duplicates using Conditional Formatting.Freezing values by copy-pasting results as values.Worked on real examples to apply and understand VLOOKUP better
1
0
0
🛠️ What I Practiced Today:.Using VLOOKUP to pull related data from a different range.Fixing table array with F4 to avoid broken formulas.Removing table formatting to return to a standard data range.Handling errors like N/A when no match is found.
1
0
0
📘 What is VLOOKUP?.VLOOKUP (Vertical Lookup) is used to search for a value in the first column of a table and return a value in the same row from another column.
1
0
0
Day 4 of Learning Excel for Data Analysis.Today I explored one of Excel’s most essential lookup functions — VLOOKUP. It’s a vital tool for retrieving and comparing data across sheets or ranges. #Excel #100DaysOfData #DataAnalytics.
1
0
0
Reflection:.Pivot Tables transform the way data is viewed and interpreted. They’re not just a feature — they’re a strategy. Excited for Day 4!. #Excel #PivotTables #DataAnalytics #100DaysOfData #ExcelTips #ExcelSkills
0
0
0
🛠️ Hands-on Experience:.Created Pivot Tables from raw data.Dragged fields into Rows, Columns, Values & Filters.Used advanced features like: .• Value Field Settings.• Percentage of Total / Difference from.• Grouping by category or date.
1
0
0
🎯 Applications in Data Analysis:.Spotting trends and patterns.Comparing performance across time or categories.Creating interactive dashboards for clear insights.
1
0
0