Automated Excel Invoice Generator with VLOOKUP Lookup Tables

Automated Excel Invoice Generator with VLOOKUP Lookup TablesAutomated Excel Invoice Generator with VLOOKUP Lookup Tables

The network for creativity

Join 1.25M professional creatives like you

Connect with clients, get discovered, and run your business 100% commission-free

Creatives on Contra have earned over $150M and we are just getting started

Back to feedPost

Kelvin Muli

• Sep 30

Automated Invoice Generator | Excel VLOOKUP + LOOKUP TABLES

Built a fully automated invoice system that eliminates manual entry:

How it works: • Select Client → Name, Address, Email auto-fills via VLOOKUP from Clients Table • Select Item Code → Description & Unit Price auto-fills from Products Table • Line Total, Subtotal, Tax (10%), Total Amount calculates automatically • Reference data hidden (Products & Clients tables) for easy updating

Formulas used: VLOOKUP, IFERROR, SUM, multiplication for totals

Result: Create a professional invoice in 30 seconds vs 15 minutes manually. Perfect for small business owners.

I can customize this with your logo, tax rate, and currency.

Data Analysis Data Entry Data Visualization Microsoft Excel

Abhinav Bajpai

• Sep 29

Self-Created Practice Project

I worked on a practice hotel booking dataset where multiple data fields were combined into a single raw-data column.

Work completed:

Separated unstructured data into individual columns using Text to Columns

Organized Booking ID, Guest Name, City, Check-In Date, Check-Out Date, Number of Pax, Amount and Status

Improved the structure and readability of the spreadsheet

Prepared the dataset for easier filtering and further use

Tool: Microsoft Excel

Skills: Data Entry | Data Cleaning | Text to Columns | Data Organization | Spreadsheet Formatting

This is a self-created practice project and not client work

Data Analysis Data Entry Microsoft Excel

Ridhi Jain

• Sep 29

Turn Your Data Into Clear, Useful Insights

Need help organizing messy data or creating professional reports?

I can help with: . Data Entry & Data Cleaning . Excel & Google Sheets . PDF/Image to Excel . Charts & Graphs . Dashboards & Reports . Pivot Tables & Summaries . Online Data Collection & Research

Accurate data. Clean spreadsheets. Professional visualizations.

DM me to discuss your project or get started!