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

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

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.

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

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

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

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

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?

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.

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.

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

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?

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?

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.

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?

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

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

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..

can you do 2023 version plsss..

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?