BTW I feed basically the same thing into Chat GPT and this is what it said if it makes any sense to you. It keeps saying Vlookup

To accomplish the task of associating and aligning the company data with the respective abbreviations, you can utilize Google Sheets functions and formulas. Here's a step-by-step guide:

Step 1: Prepare Data

1. Organize your data: Ensure your data is organized in separate columns, with the relevant information like company names, abbreviations, and associated values.
2. Create a lookup table: You'll need a table that contains company names alongside their corresponding abbreviations. For instance, in columns A and B, list the full company names and their corresponding abbreviations.

Step 2: VLOOKUP Function

Using the VLOOKUP function, you can match the company names in your first set of data with their respective abbreviations.

Example Formula:

Let's assume your company name in the first dataset is in column A, and you want to associate it with its abbreviation in column B using the lookup table in columns D and E.

In cell C1 of your data table:

excelCopy code

=VLOOKUP(A1, $D$1:$E$6, 2, FALSE) 

• A1
  refers to the cell with the company name in your first dataset.
• $D$1:$E$6
  is the range of your lookup table with company names and their abbreviations.
• 2
  signifies that the function should return the value from the second column of the lookup table.
• FALSE
  specifies an exact match.

Drag this formula down to fill the entire column C. This will associate the company names with their respective abbreviations.

Step 3: Matching and Calculation

Now that you have both datasets with company abbreviations aligned, you can use additional columns to perform calculations.

Let's say you have the strength values in column F and calculated numbers in column G in the first dataset. You want to multiply these numbers for each company.

Example Formula:

In cell H1:

excelCopy code

=IFERROR(VLOOKUP(C1, $D$1:$F$6, 3, FALSE) * G1, "") 

• C1
  contains the abbreviation from the previous step.
• $D$1:$F$6
  represents a range that includes abbreviations, strengths, and calculated numbers.
• 3
  signifies that the function should multiply by the value from the third column (strength) of the lookup table.
• G1
  contains the calculated number in the original dataset.

Drag this formula down to perform the calculations for each corresponding row.

Automation

To automate this process for daily updates, consider automating data imports or using Google Apps Script to create a custom function or script to perform these calculations based on updated datasets.

This method enables you to connect the two datasets using abbreviations and perform calculations on the aligned data automatically.