Japanese version. If there is a list of products, etc., it is possible to enter them by means of a pull-down list, from which the necessary items can be retrieved to avoid input errors. Here we will show you how to link the VLOOKUP function with a drop-down list of Data Validation. The same procedure can be used with the XLOOKUP function. Steps Prepare a worksheet like the one below as a sample. Next, prepare a sheet for searching. In this sheet, when you select a product, you will automatically get the price. Set Data Validation(pull-down). Select the range of cells for which you want to set the pull-down and … Continue reading How to select from an pull-down list to find the corresponding value.(Microsoft Excel)