ThisItem.'Account Name:Account No'.Value
ThisItem.'Account Name:Sort Code'.Value
LookUp(
YourLookedUpList,
'Account Name' = ComboBoxName.Selected.Value
).'Account No'
LookUp(SharePointList, 'Account Name' = dropdownOrcombobox.Selected.'Account Name').'Account Number'
LookUp(SharePointList, 'Account Name' = dropdownOrcombobox.Selected.'Account Name').'Sort Code'
Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.