Although we can create External Data Sets in Excel that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Excel formula.
We will look at an example that enables us to lookup a customer’s total revenue value from an Excel Formula.