Forum Discussion
VLOOKUP equivalent in SharePoint?
I am attempting to link separate SharePoint Lists through a lookup function. How would I set up a lookup column equivalent in SharePoint so a part number entered in a new row in 'List A' will referen...
ldurbin in your lookup column in List A select the column in List B which has the part number then check the boxes for the other columns which you want added as well.
Note, if a column in your List B is a choice column you will need to add a calculated column and have the calculation as =[the choice column] and return the result as a single line of text. The lookup then references that calculated column. This is because a Lookup column cannot look up a choice column.
Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)