Add Or Change Lookup Column That Lets. Locate Last Number in List. Now I want to get their corresponding months which is in the first column.
Select the lookup column and then on the Home tab select Change Properties. Create a Calculated Title column called Active Projects with a calculation of IFStatusActiveTitle. On the Change Site Column page under Add a column to show each of these additional fields verify that the names of the secondary lookup columns are selected.
In the new section add a lookup column such as the Primary Contact lookup column.
Enter the column width for each column. LOOKUPVLOOKUPE2 A2C7 3 FALSE cdt CompletedDevelopmentTesting. In the example shown the formula used to lookup all Q3 results is. On the Controls tab select Add Control in the list of control types select Form Component Control and then select Add.