00:00We can create a lookup table like this using a simple xlookup function.
00:04In the past two videos, I've demonstrated how to do the same lookup table using dget
00:08and vlookup.
00:10The links to these two videos are in the description.
00:13First I'll go ahead and create a pulldown menu for UUID.
00:16This step is not necessary but I'm adventurous.
00:18The steps to creating this pulldown menu is in the screen.
00:21This is how I use the xlookup, equal xlookup, open parenthesis, UUID, press F4 to make it
00:29fixed, comma, the UUID from the database table, and then press F4 to make it absolute reference.
00:36And after that, the third argument will be the remaining, starting from column B of your
00:40database table and F4 to make it into absolutes, cross parenthesis, and you can see the data
00:45is available for you.
00:46If you have a vertical table, you can use the same formula.
00:49However, you need to nest the xlookup function inside a transpose function.
Comments