VLOOKUP AND Dropdown Lists : The dynamic duo
Discover VLOOKUP in less than 9 minutes with my quick and simple tutorial. I'll guide you through the essential techniques in record time, so you can start unleashing the power of VLOOKUP right away. Using dropdown lists with VLOOKUP and other lookup features is a real game changer so we’ll go over that too!
Пікірлер: 5
good one
Another excellent tutorial! Thanks!
@excelgoat
Жыл бұрын
Glad you liked it!
I had done this, but when change the dropdown list (D3), the vlookup data (D5, D7 & D9) didnt change.. it only will change when i click to D3 formula and refresh it.. am i doing anything wrong?
@excelgoat
4 ай бұрын
Hi, it sounds like your calculations are turned off in Excel. If you click on formulas in the top bar and then calculation options it should be set to automatic