automatically get values from another sheet

see i have a sheet named vessel and it contains fields as vesselname and displayowner(need tobe taken from the display owner field) and i have another sheet named shipowner contains fields as VesselName and owner (contains owner data) , the vesselname in vessel sheet , the VesselName in shipowner sheet are having same values now i want to know how can i get the displayowner field gets filled by cross checking the vesselnames . I mean it should check the vesselnames and if they are equal then it should look for the corresponding owner name and that should automatically get filled in the displayowner feild

Hi there,

To achieve your goal of automatically filling the DisplayOwner field in your Vessel sheet based on the matching VesselName from the ShipOwner sheet, we recommend using Ragic’s Link & Load feature.

This feature allows you to link records between two sheets via a shared key field—in your case, VesselName. Once the link is established, you can automatically “load” related data—such as the Owner field—into your current sheet.

Here’s how it would work in your scenario:

  • In your Vessel sheet, set up a Link & Load relationship with the ShipOwner sheet using the VesselName field as the link field.
  • Then, configure the DisplayOwner field to load the Owner value from the ShipOwner sheet.

Check out the user guide here for more details:
:link: Link and Load

Hope this helps!