1. Use VLOOKUP to pull the values from Pivot21 for each column: 2021 Hours w/errors, 2021 Gross Pay w/errors, and 2021 Gross Pay per Hour w/errors A. Lookup_value: UniqueID on Analysis worksheet (for all three columns) B. Table_array: DATA ONLY from Pivot21 WITH ABSOLUTE REFERENCES (for all three columns) C. Col_index_num: increments up from 1, where 1 is the first column (UniqueIDs) on Pivot21 D. Range_lookup: FALSE E. Number Formats: E1. 2021 Hours w/errors: Number, 2 decimals E2. 2021 Gross Pay w/errors: Currency, $, 2 decimals E3. 2021 Gross Pay per Hour w/errors: Currency, $, 2 decimals