Spreadsheet: 122472d1316829505-how-do-i-automatically-attach-data-to-terms-i-copy-into-excel-vlookup-example-for-forum
Sheet: Sheet1

TERMS | NUMBERS |  |  |  |  |  |  |  |  |  | LOOK TERMS | LOOK #'s
TRF | 5 |  |  |  |  |  |  |  |  |  | OVERTIME | 4
OVERTIME | 4 |  |  |  |  |  |  |  |  |  | REGULAR | 3
REGULAR | 3 |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
NIGHT SHIFT | 2 |  |  |  |  |  |  |  |  |  | TRF | 5
PREMIUM PAY | 1 |  |  |  |  |  |  |  |  |  | PREMIUM PAY | 1
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | HOLIDAY | #N/A
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | MARTIAN | #N/A
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | HOLIDAY | #N/A
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | PREMIUM PAY | 1
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | PREMIUM PAY | 1
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | HOLIDAY | #N/A
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | MARTIAN | #N/A
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | HOLIDAY | #N/A
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | PREMIUM PAY | 1
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | PREMIUM PAY | 1
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | HOLIDAY | #N/A
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | MARTIAN | #N/A
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | HOLIDAY | #N/A
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | PREMIUM PAY | 1
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | PREMIUM PAY | 1
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | PREMIUM PAY | 1
 |  |  |  |  |  |  |  |  |  |  | REGULAR | 3
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4
 |  |  |  |  |  |  |  |  |  |  | NIGHT SHIFT | 2
 |  |  |  |  |  |  |  |  |  |  | TRF | 5
 |  |  |  |  |  |  |  |  |  |  | OVERTIME | 4