In this video we will show you how to create a lookup of key values from a related table in SQL Server using SQL Spreads.
00:00 Intro
00:15 Lookup a key value in a database table
01:20 Lookup a key value in a simple list of key-value pairs
02:19 Summary
The key values in Excel will be replaced with a drop-down list that shows texts fetched from the related table in SQL Server.
We will also create lookup of key values from a simple list of keys and texts in SQL Spreads.
Learn more about using Excel to update data in SQL Server and download the 14-days Free Trial at
https://sqlspreads.com