You can use VLookup between sheets within an Excel workbook ... table array, separated by an exclamation mark. This makes the VLookup formula reference the cell range on another sheet. For the ...