Excel VLOOKUP Test Price Comparison

Job ID: 39960548

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.