Excel’s VLOOKUP function is undoubtedly one of the most popular Excel functions. It can readily interpret and report values in large data arrays and unlike a PivotTable, which needs to be manually updated to reflect source data changes; VLOOKUP will seamlessly update to reflect such changes.
This is a fast approach to add a level of sophistication and reduce input error in your spreadsheet. It is a great technique because it will flex, based on the value chosen in a precedent drop-down list.
Here is an effective and simple technique to incorporate a dynamic approach to a drop-down list of inputs. It offers a more effective approach than creating a dynamic name range.