I have these tables
|First Name||Last Name||Full Name||Role||Company Name||Decision Maker?||Type||Phone Number|
The Type Column above should seek to match the Company Name in the Lookup table Companies (below) and return the value of Type for xyz ltd.
|Company Name||Type||Phone Number||Address||Date Created||Creator||Assigned Team Member|
I know that my problem is associated with the need to format to text but I can’t get the formula right. Any help much appreciated. Also, how can I format to show the table layout here…