I will fix the excel vlookup formula
I will clean, format and organize your Excel or Google Sheets data
About this Gig
What I offer in the gig
Excel Formula Creation & Fixing
VLOOKUP, HLOOKUP, INDEX-MATCH
IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, SUMPRODUCT, SUMIFS
REMOVING DUPLICATES, X-LOOKUP, INDEX, SEARCH,
Data Validation & Drop-Down Lists
Conditional Formatting for Dynamic Data Highlighting
Formula Automation & Linking Multiple Sheets
Fixing Common Errors (#DIV/0, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!)
Data Conversion & Processing
Convert PDFs, Text Files & Images into Excel
Extract and Structure Data for Easy Analysis
Splitting the text/data/Formula into different cells
Formulate any related issues as per your requirements.
Platform:
Excel
•
Google Sheets
•
Power BI
Development technology:
Excel
•
DAX
•
VLOOKUP
Expertise:
Fixing
•
Pivot tables
•
Formulas
•
Power Query
•
Modeling
