Excel VLOOKUP Test Price Comparison
Budget: ₹100 – ₹400 INR
I have two price lists—each from a different company—that cover identical medical test names. I need one clean Excel workbook that instantly shows which company is cheaper for every test.
Here’s what I’m after:
• A simple, easy-to-read layout you design for me (I don’t have a template).
• Side-by-side columns: Company A price, Company B price, plus an automatic price-difference column.
• VLOOKUP, XLOOKUP, or INDEX-MATCH formulas so the sheet updates correctly when I paste in fresh price lists.
• Basic conditional formatting that highlights the lower price at a glance.
The final file should be ready for me to drop in updated lists without breaking anything, and all formulas must be visible and editable—no hidden code or macros.
Here’s what I’m after:
• A simple, easy-to-read layout you design for me (I don’t have a template).
• Side-by-side columns: Company A price, Company B price, plus an automatic price-difference column.
• VLOOKUP, XLOOKUP, or INDEX-MATCH formulas so the sheet updates correctly when I paste in fresh price lists.
• Basic conditional formatting that highlights the lower price at a glance.
The final file should be ready for me to drop in updated lists without breaking anything, and all formulas must be visible and editable—no hidden code or macros.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Excel VBA
Excel Macros
Data Visualization
Data Analysis