"Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?". Using the set up from Episode #1379, today's Duel adds Dynamic Validation and Dynamic VLOOKUP using OFFSET or INDEX. Let Mike and Bill show us how it's done!