00:00You can create a lookup feature like this using a simple dget function before you roast me with
00:05why not use vlookup and xlookup. Yes, you can use this function too, which I will make another video
00:11about it. For now, this is how you can use dget function. Let's make the UID into a pulldown
00:16menu. Select the UID in A2 here and go data and go data tools and go data validation. On this popup
00:22here, you're going to select list and then on the source, you're going to select all the UID on your
00:26table like this and click OK. Now you have a pulldown menu like this. Next, you're going to use
00:30the dget function here. So equal, dget, open parenthesis and you're going to select the
00:34whole database table here like this and then you're going to press F4 to make it into a fixed
00:38reference, comma, and you're going to select this name here, model for the field, comma, and then the
00:44criteria will be the UID including the header itself and press F4 again to make it to fix. All you have
00:49to do now is to copy ctrl c, ctrl v, ctrl v, and ctrl v and you'll fill up everything and you change
00:55on your lookup menu here. All this will change accordingly.
Comments