How to Use a Lookup Field Column in SharePoint Lists | Microsoft SharePoint | 2022 Tutorial

Hi Everyone,

In this video, I demonstrate how to use a Lookup Field column in SharePoint Lists. This is useful for connecting information from two lists.

If you enjoy this video like, comment, and subscribe.

#LookupField #SharePoint #SharePointLists

[johnbrennan]

The most to the point best explanation of a lookup column I have seen yet and I have seen many, well done

[rdiklhl]

That is exactly what I was looking for :) Thank you Michael for the great explanation!
Greets from Germany

[myceliumcodes]

Thanks for the video, great explanation. Do you know if it's possible to automate the relationship on both tables? So when I add say a resource to a task (on a List of tasks), I'd also like to see on the List of Resources, all the tasks associated with it. Airtable does this really well, interested to see if Lists can do something similar. Cheers.

[MawuliAsamoa]

Hey, great video. Thanks for the tutorial. Do you know why after setting this up you cannot add new rows using the edit grid mode? only works when you use the +New button. thanks

[urdecisionisurs]

Another great video; if I wanted to create a onboarding process in Sharepoint can I also link it to another list?

[heidishiu]

I successfully brought in the first column from another list, but the additional columns from that same list won’t populate but greyed out? Do u know why?

[peterkaprinyak]

Hi, if I have a look up column in SP list, how can I see more field in the drop down menu from another list data? For example I have a "A" list with look up menu and "B" list with 2 columns. So I create a new record in "A" list and open drop down menu, but I see only one column data from "B" list. I would like see in drop down from "B" list 1 and 2 column in "A" list. Is it possible?

[shathike]

Hi Michael, this is good informative, kindly let me know, lookup field not working for date format its visible number format (i.e. 44, 745) please guide me how to change as date format. Thanks

[pwemrqw]

What if one of them is in the form of a library list?

[vs_gaming]

IS it possible to create a lookup column based on condition? (Lookup value based on value in other column (IF formula)? It's possible to create a calculated field but there is only the option to set the resulting value like text, integer, date... but not a list with options.

[Damodar.Shetty]

Hello & this is really well explained
But for me only 1 column details appear other column details are not appearing but headers are....

[snailprogrammer]

Can this be automated? I have a form that asks the person filling out the form their company. So based on that company (W1234) it will populate the parent company. I have the form connected to Lists via Power Automate. Basically need something similar to a VLOOKUP in excel.

[marsontran]

Thank you Michael, is there a way to lookup a drop-down choice column from a list? So far I can only copy from a "text only" type of column.

[drkmccy]

Thanks, that was useful. Can you lookup a list in another SP site or do all the lists have to be in the same site?

[alejandroladreyt]

Hello Michael! Very helpful and precise tutorial! I have a question, what if the person has 2 telephone numbers, is there a way to select which one do we want?

[arilion]

Thank you, it could be linked with a list from a different site?

[abdulrahmanbaamer]

Hi, excellent video as usual.
I need the lookup work based on a column in the current list. I.e. I don't want to select manually the contact name and based on that it returns the contact number.

I want to lookup a value in a column from the current list, look it up in another list and returns the needed columns.

Is this possible?

Thanks..

[Plopperzz]

I have an issue where the name column is blank, but the lookup correctly populates the other cells. Is this an error on my part?