Learn how to make VLookup function use cell value from a single cell or an array in another sheet as a table array reference.