Automate Excel Lookup Formulas

The task is to populate an Excel workbook with robust VLOOKUP or HLOOKUP formulas that draw live data from an online database I provide. All raw figures sit in this database and must flow cleanly into the sheet so that calculations refresh automatically whenever the source updates. Accuracy is key; the formulas have to return the exact matches every time, handle missing entries gracefully, and remain easy to audit or expand later.

I will supply:
• Database credentials or a direct CSV export link.
• A skeleton workbook showing where each lookup result should appear.

Deliverables:
• A finished Excel file with all required VLOOKUP or HLOOKUP formulas in place and tested.
• A short note (or annotated worksheet) explaining the logic behind each formula so future edits are painless.

Everything can be handled in standard Excel; if Power Query or another built-in tool speeds things up, feel free to use it as long as the final workbook stays fully functional for any user with Excel 2016 or newer.