00:00We can create a lookup feature like this using a basic VLOOKUP function. In my
00:04previous video I had demonstrated how to use DGET function. Please refer to the
00:08description of this video for the URL link. The first step we're gonna do is
00:12to create a UID with a pulldown menu. The steps are listed here. To use a VLOOKUP
00:17say equal VLOOKUP. The first argument will be the UID. Press F4 to make it
00:22fix. The second argument on that VLOOKUP will be the data set table itself.
00:26And press F4 to make it fix as well. Comma. The third argument is your
00:29field which is your model which is number 2, 0. As you can see if you do the
00:33next one it's gonna be 3 and 4 and so on but this is a bit tedious. The better way
00:38to do this would be to basically put the fields in a curly braces separated by a
00:41comma 3, field number 4 and field number 5. And this will give you data in a
00:45horizontal format. If your data set table is in vertical format you can use the
00:49same formula. The only difference would be that instead of using a curly braces and
00:53a comma you're gonna use semicolon like this to separate each field and your
00:57data set will be in a vertical format.
Comments